Question

In: Accounting

Note- after is says answer, those are the answer choices Scenario: Tracy Clark just recently completed...

Note- after is says answer, those are the answer choices

Scenario:

Tracy Clark just recently completed her first year of full time work. She has no children, is not married, and is enrolled full time in college. Now she needs to complete the W-2 form. She has worked for a full year at the Happy Hotel. She earned a total of $22,000 this year. She knows from looking at her paycheck stubs that she had a total of $432 of federal income withheld. She also noted that she had $500 of social security tax as well as $332 of medicare tax withheld from her paycheck. With this knowledge help Tracy complete her W-2 form.

Directions:

Please complete the W2 form by answering the questions that follow.

  1. Wages, tips and and other compensation: Answer 22,000 500 432 none
  2. Federal Income Witheld: Answer 432 22,000 500 none 332
  3. Social Security Wages: Answer 22,000 432 500 none 332
  4. Social Security Tax Witheld: Answer 50043222,000 none 332
  5. Medicare Wages and Tips: Answer 22,000 500432none332
  6. Medicare Tax Witheld Answer 332 none50022,000432
  7. Social Security Tips: Answer none 33243222,000500
  8. Allocated Tips: Answer none 33243250020,000

Solutions

Expert Solution

To solve this question just input those variables which are to be used in logistic regression, as the question talks about using two variables only that is total loans and leases to total assets & total expenses/ total assets, so we will not input total cap/assets as an input variable in our excel, here we go

As one can see, we have taken only two variables , total exp/assets and total lns & leases/ assets in calculation, follwing steps have been followed to construct the above table

1. Assume logit= b0+ b1* independent variable1+ b2* independent variable 2 , take values of b0=0.1, b1=0.1, b2=0.1, note that these values of b0, b1 and b2 are just taken for calculation, one could assume any values here for bo , b1 and b2

2. Calculate exponential of logit in the next column by using exp (value in previous column)

3. Calculate probability by using formula, probability= exp (logit)/ { 1+ exp(logit)} in the next column

4. In next column, calculate log likelihood by using formula : financial condition value (i.e. 1 or 0) * LN( probability calculated in previous column) + (1- financial condition value)* LN( 1- probability calculated in previous column)

5. take the total of the column values of log likelihood

6. use solver function in excel to change this total by putting max value of 0 and changing the variable cells containing assumed values of b0, b1 and b2 , by clicking on solve, you will get actual values of b0, b1 and b2

which comes out to be b0=-14.72, b1=89.83, b2= 8.37

therefore you will get logit as

-14.72+ 89.83* Total exp/assets+8.37*Total lns & lsses/ assets

With values given in the question as total exp/ assets= 0.11 and total loans & leases/ assets= 0.6 , we get

logit as -14.72+ 89.83* 0.11+ 8.37*0.6= 0.1833

exp (logit) = 1.20

Probability= 0.546

Loglikelihood= 1*LN(0.546)+0*LN(1-0.546)= LN(0.546)= -0.605


Related Solutions

Scenario: You recently became a partner in a firm. After working there for 6 months as...
Scenario: You recently became a partner in a firm. After working there for 6 months as a partner, you attend a meeting regarding a business loan that is up for renewal. You discover that the collateral for the loan is all of the accounts receivable. Do you have an issue with using the accounts receivable for collateral? Why or why not?
IMPORTANT NOTE*****Read the following scenario, and write one or two paragraphs to answer each of the...
IMPORTANT NOTE*****Read the following scenario, and write one or two paragraphs to answer each of the sub-questions below: Consider a small, but growing, company that distributes kitchen supplies. The customers are primarily small retailers such as kitchen specialty stores, hardware stores, and other types of home retail stores. Managers currently keep track of all customers, orders, and inventory information using a spreadsheet. a. If a TPS was set up to automate the order entry and inventory system, provide two examples...
IMPORTANT NOTE*****Read the following scenario, and write one or two paragraphs to answer each of the...
IMPORTANT NOTE*****Read the following scenario, and write one or two paragraphs to answer each of the sub-questions below: Consider a small, but growing, company that distributes kitchen supplies. The customers are primarily small retailers such as kitchen specialty stores, hardware stores, and other types of home retail stores. Managers currently keep track of all customers, orders, and inventory information using a spreadsheet. a.Describe how a TPS would help the managers of this company keep track of orders and inventory. b.Identify...
Case #1 Suppose that you recently completed your MBA and have just reported to work as...
Case #1 Suppose that you recently completed your MBA and have just reported to work as an investment advisor at the consultancy firm of Wais and Qais Inc. One of the firm’s clients is Saad, a professional table tennis player who has just come to the Afghanistan from Japan. Saad is a highly ranked table tennis player who would like to start a company to produce and market kit he designs. He also expects to invest substantial amounts of money...
Scenario: BizCon, a consulting firm, has just completed its first year of operations. The company's sales...
Scenario: BizCon, a consulting firm, has just completed its first year of operations. The company's sales growth was explosive. To encourage clients to hire its services, BizCon offered 180-day financing - meaning its largest customers do not pay for nearly 6 months. Because BizCon is a new company, its equipment suppliers insist on being paid cash on delivery. Also, it had to pay up front for 2 years of insurance. At the end of the year, BizCon owed employees for...
Answer these questions are based on a recently completed group project that you have been involved...
Answer these questions are based on a recently completed group project that you have been involved in. This project may have been a student project, a work project, an extracurricular project, or a project in one of the case studies in the book. 1. Analyze the development of the team in terms of the five-phase model and the punctuated equilibrium model. Which model does the best job of describing how the team evolved? 2. Analyze the group in terms of...
The Scenario: After recently graduating from KSU, you begin a career as an product investment analyst...
The Scenario: After recently graduating from KSU, you begin a career as an product investment analyst with Hormel Foods. As the newest Skippy P.B. analyst, your first assignment is to evaluate the following enterprise. The Skippy P.B. Fruit Bites machine will initially cost $200,000. Hormel expects to use the machine for 10 years. After 10 years, the machine will be worth $20,000 in today’s prices. The machine will be depreciated using straight‐line depreciation over 8 years and the salvage value...
Match each scenario below with the most appropriate inferential technique. Group of answer choices We want...
Match each scenario below with the most appropriate inferential technique. Group of answer choices We want to test if at least half of students at a university feel as if the dorms need to be renovated. We want to estimate the average number of calories in a combo meal at fast food restaurants. The population standard deviation is unknown. We want to test if the average number of miles that motorists drive between oil changes is greater than the recommended...
Please Answer the following: 1.Kenneth Clark just received a cash gift from his grandfather. He plans...
Please Answer the following: 1.Kenneth Clark just received a cash gift from his grandfather. He plans to invest in a five-year bond issued by Pharoah Corp. that pays an annual coupon rate of 5.5 percent. If the current market rate is 7.00 percent, what is the maximum amount Kenneth should be willing to pay for this bond? (Round answer to 2 decimal places, e.g. 15.25.) Kenneth Should Pay ? 2.Oriole, Inc., has issued a three-year bond that pays a coupon...
Your friend, Diana Wood, recently completed the second year of her business and just received annual...
Your friend, Diana Wood, recently completed the second year of her business and just received annual financial statements from her accountant. Wood finds the income statement and balance sheet informative but does not understand the statement of cash flows. She says the first section is especially confusing because it contains a lot of additions and subtractions that do not make sense to her. Wood adds, “The income statement tells me the business is more profitable than last year and that's...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT