Case Study B: Applying Accounting Practices for Assets Mustang Company reported the following financial information for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Case Study B: Applying Accounting Practices for Assets Mustang Company reported the following financial information for its first year of operations. Below are the financial statements for the year ended December 31, 2019: Mustang Company Balance Sheet As At December 31, 2019 Assets Current Assets Cash Accounts Receivable Less: Doubtful Accounts Inventory Prepaid Expenses $5 660 $52 000 3 750 48 250 146 410 3 200 Total Current Assets $203 520 Property, Plant & Equipment Land Building Less: Accumulated Amortization 200 000 $80 000 8 000 72 000 Equipment Less: Accumulated Amortization Total Property Plant and Equipment Total Assets 40 000 8 000 32 000 304 000 $507 520 Liabilities & Owner's Equity Current Liabilities Accounts Payable Wages Payable Mortgage Payable - Current Portion Total Current Liabilities $77 000 2 350 20. 000 $99 350 Long Term Liabilities Mortgage Payable Total Liabilities 220 000 319 350 Owner's Equity J. Mustang, Capital Total Liabilities & Owner's Equity 188 170 $507 520 Income Statement Year Ended December 31, 2019 Revenue Sales $375 000 199 590 Cost of Goods Sold Gross Profit $175 410 Operating Expenses Wages Depreciation-Equipment Depreciation - Building Interest Bad Debts Miscellaneous $65 800 8 000 8 000 7 200 3 750 24 000 116 750 Net Income $58 660 Additional Information Relating to the Income Statement: i) Cost of Goods Sold has been calculated as follows: Cost of Goods Available for Sale: Less: Ending Inventory Cost of Goods Sold $346 000 146 410 199 590 ii) The record of purchases and sales during 2019 show the following: 6 000 units January Sales - Jan to April May Sales - May to August Sales September Sales - Oct to Dec Purchases Sales @ $11 @ $25 10 000 units @ $13 5 000 units @ $25 10 000 units @ $15 6 000 units 4 000 units Purchases Purchases Sales @ $25 Additional Information Relating to the Balance Sheet: The estimated useful life of the equipment is 10 years or 20,000 hours of usage with a residual value of $5,000. The company used the equipment for 4,571 hours during the first year. The estimated useful life of the building is 10 years with a salvage value of i) ii) $12,000. ii) The accounts receivable aging schedule is as follows: Number of Days Outstanding 0-30 days 31-60 days 61-90 days Over 90 days Estimated % Amount Uncollectible 1% 5% $30,000 12,000 8,000 2,000 10% 30% J. Mustang has consulted you because of his dissatisfaction with the financial results for the year. Mr. Mustang is hoping you can recast the financial statements to show the business in a better in a better financial position. Required: 1. Determine the accounting policies used in the preparation of the financial statements with regard to Cost of Goods Sold and Depreciation Expense. Show all calculations. 2. Provide an alternative value for Cost of Goods Sold and Depreciation Expense. Explain how you arrived at these values. Show all calculations. 3. The bad debt expense reported on the Income Statement was calculated by using the percentage of sales approach. Using the aging schedule provided above, determine an alternate amount for bad debt expense. Nordstar Inc. operates hardware stores in several provinces. Selected comparative financial statement data are shown below. Nordstar Inc. Balance Sheet (partial) December 31 (in millions) 2019 2018 2017 Current Assets Cash $30 91 60 Short-term investments 55 60 40 Accounts receivable 676 586 496 Inventory Prepaid expenses Total current assets 628 525 575 41 52 $1,430 $890 $1,314 $825 29 $1,200 $750 Total current liabilities Additional information (in millions): 2019 Net Credit Sales Cost of Goods Sold Net Income 2018 $3,940 2,650 $4,190 2,900 290 310 Required: a) Calculate all possible liquidity ratios for 2019 and 2018. Determine whether the liquidity of Nordstar Inc. improved or deteriorated from 2018 to 2019. b) Given the information above, determine the net cash flows from operating activities for 2018 and 2019. c) As a potential creditor to Nordstar Inc., outline any concerms you may have with respect to selling on credit to Nordstar. Level 1 0-5 marks Level 2 Level 3 Level 4 11-15 marks 16-20 marks CATEGORY Application - 6-10 marks ТОTAL Applies concepts to case facts in order to solve the issues Applies concepts with limited Applies concepts with some Applies concepts with a considerable amount of Applies concepts with a high degree of effectiveness /20 effectiveness effectiveness effectiveness Case Study B: Applying Accounting Practices for Assets Mustang Company reported the following financial information for its first year of operations. Below are the financial statements for the year ended December 31, 2019: Mustang Company Balance Sheet As At December 31, 2019 Assets Current Assets Cash Accounts Receivable Less: Doubtful Accounts Inventory Prepaid Expenses $5 660 $52 000 3 750 48 250 146 410 3 200 Total Current Assets $203 520 Property, Plant & Equipment Land Building Less: Accumulated Amortization 200 000 $80 000 8 000 72 000 Equipment Less: Accumulated Amortization Total Property Plant and Equipment Total Assets 40 000 8 000 32 000 304 000 $507 520 Liabilities & Owner's Equity Current Liabilities Accounts Payable Wages Payable Mortgage Payable - Current Portion Total Current Liabilities $77 000 2 350 20. 000 $99 350 Long Term Liabilities Mortgage Payable Total Liabilities 220 000 319 350 Owner's Equity J. Mustang, Capital Total Liabilities & Owner's Equity 188 170 $507 520 Income Statement Year Ended December 31, 2019 Revenue Sales $375 000 199 590 Cost of Goods Sold Gross Profit $175 410 Operating Expenses Wages Depreciation-Equipment Depreciation - Building Interest Bad Debts Miscellaneous $65 800 8 000 8 000 7 200 3 750 24 000 116 750 Net Income $58 660 Additional Information Relating to the Income Statement: i) Cost of Goods Sold has been calculated as follows: Cost of Goods Available for Sale: Less: Ending Inventory Cost of Goods Sold $346 000 146 410 199 590 ii) The record of purchases and sales during 2019 show the following: 6 000 units January Sales - Jan to April May Sales - May to August Sales September Sales - Oct to Dec Purchases Sales @ $11 @ $25 10 000 units @ $13 5 000 units @ $25 10 000 units @ $15 6 000 units 4 000 units Purchases Purchases Sales @ $25 Additional Information Relating to the Balance Sheet: The estimated useful life of the equipment is 10 years or 20,000 hours of usage with a residual value of $5,000. The company used the equipment for 4,571 hours during the first year. The estimated useful life of the building is 10 years with a salvage value of i) ii) $12,000. ii) The accounts receivable aging schedule is as follows: Number of Days Outstanding 0-30 days 31-60 days 61-90 days Over 90 days Estimated % Amount Uncollectible 1% 5% $30,000 12,000 8,000 2,000 10% 30% J. Mustang has consulted you because of his dissatisfaction with the financial results for the year. Mr. Mustang is hoping you can recast the financial statements to show the business in a better in a better financial position. Required: 1. Determine the accounting policies used in the preparation of the financial statements with regard to Cost of Goods Sold and Depreciation Expense. Show all calculations. 2. Provide an alternative value for Cost of Goods Sold and Depreciation Expense. Explain how you arrived at these values. Show all calculations. 3. The bad debt expense reported on the Income Statement was calculated by using the percentage of sales approach. Using the aging schedule provided above, determine an alternate amount for bad debt expense. Nordstar Inc. operates hardware stores in several provinces. Selected comparative financial statement data are shown below. Nordstar Inc. Balance Sheet (partial) December 31 (in millions) 2019 2018 2017 Current Assets Cash $30 91 60 Short-term investments 55 60 40 Accounts receivable 676 586 496 Inventory Prepaid expenses Total current assets 628 525 575 41 52 $1,430 $890 $1,314 $825 29 $1,200 $750 Total current liabilities Additional information (in millions): 2019 Net Credit Sales Cost of Goods Sold Net Income 2018 $3,940 2,650 $4,190 2,900 290 310 Required: a) Calculate all possible liquidity ratios for 2019 and 2018. Determine whether the liquidity of Nordstar Inc. improved or deteriorated from 2018 to 2019. b) Given the information above, determine the net cash flows from operating activities for 2018 and 2019. c) As a potential creditor to Nordstar Inc., outline any concerms you may have with respect to selling on credit to Nordstar. Level 1 0-5 marks Level 2 Level 3 Level 4 11-15 marks 16-20 marks CATEGORY Application - 6-10 marks ТОTAL Applies concepts to case facts in order to solve the issues Applies concepts with limited Applies concepts with some Applies concepts with a considerable amount of Applies concepts with a high degree of effectiveness /20 effectiveness effectiveness effectiveness
Expert Answer:
Answer rating: 100% (QA)
Tax 2019 15 million 2018 issue 36 million equity shares and 10 million 8 c... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Mustang Company reported the following financial information for its first year of operations. Below are the financial statements for the year ended December 31, 2019: Assets Current Assets Cash...
-
The following financial information is for HKUST Company, a non-U.S. firm with shares listed on a U.S. stock exchange. Net income, computed according to home country GAAP . . . . . . . . . . . . . ....
-
For 2010, its first year of operations, Quinn Advertising, Inc. earned pretax accounting income (on the income statement) of $375,000. Taxable income (on the tax return filed with the Internal...
-
In Exercises solve the first-order differential equation by any appropriate method. y' = 2x1 - y
-
Listed below in random order are the items to be included in the balance sheet of Deep River Lodge at December 31, 2011: Instructions a. Prepare a balance sheet at December 31, 2011. Include a proper...
-
Prime Corporation begins operations in late 2015. Prime decides to use the single-pool LIFO method. Year-end inventories under FIFO are as follows: 2015 . $110,000 2016 . 134,000 2017 . 125,000 The...
-
Compute the missing amounts in the following financial statements. You may assume that accounts receivable relate only to credit sales and that accounts payable relate only to credit purchases of...
-
Semtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Semtech made the following expenditures in connection with the purchase of the land and building:...
-
Required information [The following information applies to the questions displayed below.] Income statement and balance sheet data for Great Adventures, Incorporated, are provided below. Net sales...
-
Write a letter to the Smith's discussing the results of their tax return, remind them of any deduction substantiation rules they need to follow (receipts, mileage log, etc.), offer suggestions for...
-
Each student will read, analyze, and produce a three page (1.5 space with 12 pt font and not including appendices) on the case organized in the following five sections from the stated perspective...
-
The balance sheet provides information about the nature and amounts of investments in enterprise resources, obligations to creditors, and the owners' equity in net enterprise resources. Please...
-
Carbon monoxide (CO) contained in a piston-cylinder arrangement, initially at 5.3 bar and 497 K, undergoes an expansion to a final temperature of 224 K, during which the pressure-volume relationship...
-
For the function evaluate the left and right limits as a -1. Provide your answer below: a. lim f(x)= x-1 b. lim f(x)= I-X x+2 if x < -1 f(x) = 1-x -x if x-1'
-
Given the number of deliberate threats to infromations systems of organizations how effectively can they be dealt with how can organization protext their information systems against their biggest...
-
The company received an order from a customer in Europe. Mr. Kunta, the management accountant, stated that the material used in the production of the goods is available in the warehouse - the...
-
Data Table 2 Part II Observing Standing Waves on the Second String Type of String: Nylon Cord Measured mass of 1.20x10 the length of Calculated mass per unit length, m, of 8.16x10-4 second string...
-
An example of prescriptive analytics is when an action is recommended based on previously observed actions. For example, an analysis might help determine procedures to follow when new accounts are...
-
The following information is from Canning Company: Required Calculate the allowance ratio for both years. Is Canning Company getting better or worse at collecting its receivables? Allowance for bad...
-
Olson Outlet Malls is trying to determine if its equity is comparable to other malls in the area. Required a. Conduct horizontal and vertical analyses for Olson. Round percentages to one decimal...
-
On January 1, 2012, Hampton, Inc. issues $3 million of 5-year, 10% bonds with interest payable on July 1 and January 1. Hampton prepares financial statements on December 31 and amortizes any discount...
-
Use the health expenditure data of Section 16.6. The model is a probit regression of DMED, an indicator variable for positive health expenditures, against just one regressor for simplicity, NDISEASE,...
-
Continue the analysis of Exercise 14.5. (a) Compare the three binary models on the basis of statistical significance of NDISEASE. (b) Compare the three binary models on the basis of the estimated...
-
Use a 50\% subsample of the fishing mode choice data of Section 15.2. (a) Estimate the conditional logit model of Section 15.2.1. (b) Comment on the statistical significance of parameter estimates....
Study smarter with the SolutionInn App