A2Category3Sales4 Cost of Goods Sold15a. Calculate ROA for current values.16 Note: Round your answers to 2 decimal places.1718 SPM Outputs19Gross Profit20BCurrent Input Values$3,237,000.00$2,490,000.00$415,000.00$161,850.00$465,000.00$162,000.00$546,000.00$492,000.005 Variable Expenses6 Fixed Expenses7 Inventory8 Accounts Receivable9 Other Current Assets10Fixed Assets1112 Required:13 Note: Use cells A2 to C10 from the given information to complete this question.14Total Expenses21Net Profit22 Net Profit Margin23Current Assets24 Total Assets25 Asset turnover26 ROA (%)2728 b. Calculate ROA for new values.29 Note: Round your answers to 2 decimal places.3031 SPM Outputs32Gross Profit33 Total Expenses34 Net Profit35 Net Profit Margin36 Current Assets37 Total Assets38 Asset turnover39 ROA (%)404142CNew Input Values$3,560,700.00$2,490,000.00$383,875.00$161,850.00$395,250.00$162,000.00$546,000.00$492,000.00DEFTIGHIJKLMM

Gross profit is the amount of money earned by the entity after deducting the cost of goods sold from…

2 Category 3 Sales A 4 5 Variable Expenses 6 Fixed Expenses 7 Cost of Goods Sold Inventory Accounts Receivable 8 9 Other Current Assets 10 Fixed Assets 11 B Current Input Values $3,237,000.00 $2,490,000.00 $415,000.00 $161,850.00 $465,000.00 $162,000.00 $546,000.00 $492,000.00 15 a. Calculate ROA for current values. 16 Note: Round your answers to 2 decimal places. 17 18 SPM Outputs 19 Gross Profit 20 Total Expenses 21 Net Profit 22 Net Profit Margin 23 Current Assets 24 Total Assets 25 Asset turnover 26 ROA (%) 27 33 Total Expenses 34 Net Profit 35 Net Profit Margin 36 Current Assets 37 Total Assets 12 Required: 13 Note: Use cells A2 to C10 from the given information to complete this question. 14 28 b. Calculate ROA for new values. 29 Note: Round your answers to 2 decimal places. 30 31 SPM Outputs 32 Gross Profit 38 Asset turnover 39 ROA (%) 40 C New Input Values $3,560,700.00 $2,490,000.00 $383,875.00 $161,850.00 $395,250.00 $162,000.00 $546,000.00 $492,000.00 D E

2 Category 3 Sales A 4 5 Variable Expenses 6 Fixed Expenses 7 Cost of Goods Sold Inventory Accounts Receivable 8 9 Other Current Assets 10 Fixed Assets 11 B Current Input Values $3,237,000.00 $2,490,000.00 $415,000.00 $161,850.00 $465,000.00 $162,000.00 $546,000.00 $492,000.00 15 a. Calculate ROA for current values. 16 Note: Round your answers to 2 decimal places. 17 18 SPM Outputs 19 Gross Profit 20 Total Expenses 21 Net Profit 22 Net Profit Margin 23 Current Assets 24 Total Assets 25 Asset turnover 26 ROA (%) 27 33 Total Expenses 34 Net Profit 35 Net Profit Margin 36 Current Assets 37 Total Assets 12 Required: 13 Note: Use cells A2 to C10 from the given information to complete this question. 14 28 b. Calculate ROA for new values. 29 Note: Round your answers to 2 decimal places. 30 31 SPM Outputs 32 Gross Profit 38 Asset turnover 39 ROA (%) 40 C New Input Values $3,560,700.00 $2,490,000.00 $383,875.00 $161,850.00 $395,250.00 $162,000.00 $546,000.00 $492,000.00 D E

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Please provide answer in text form with explanation computation for each steps clearly and correctly
Below are the Income Statement of ABC Company for two consecutive years. ABC Company Net Sales Cost of Goods Soldxs3 Year 1 P 5,000,000 880,000 Year 2 P 6,500,000 950,000
What is the current ratio? Use the information below. Current Assets $450,000 Costs of Goods Sold: $2.000,000 Inventory $250,000 Total Sales $3.000,000 Acct Rec: $200,000 Credit Sales: $1,500,000 Total Assets $900,000 Total Purchases: $2,500,000 Current $300,000 Operating Expenses: $700.000 Liabilities: Acct Payable $100,000 Pre-Tax Income: $60.000 Total Liabilities: $600,000 Owner's Equity $300.000
Please show me the work (formulas in excel)
Exercise 13-3 (Algo) Computing and analyzing trend percents LO P1 Sales Cost of goods sold Accounts receivable. 2021 $ 706,675 363,004 34,274 2020 2019 $464,918 $ 371,9341 238,808 193, 136 27,058 25,477 2018 $ 260,094 133,898 15,268 2017 $ 194, 100 98,991 13,296 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.
Sales Revenues Cost of goods sold Fixed costs 48 16 Selling, general, and administrative expenses 22 Depreciation EBIT |laxes| 19 pastor Profit illa ESINOPATI 7 *** Tax rate Dividends paid ASSETS Current Assets Lish Accounts receivable Inventories Total current assets Cross Fixed assets Accumulated depreciation Net Fixed assets Intangible assets TOTAL ASSETS 40% $10 Partial Balance Sheet 12 31 2019 $4 6 LIABILITIES Current Liabilities Accruals Accounts payable 5 Total current liabilities Long-term debt Total Liabilities 70 OWNERS EQUITY 10 Retained earnings Common stock 0 total owner's equity |IOTAL LIABILITES & OWNERS SQUITY These are surtulative reliános szarnings haut textsenck strapl, calkat nainsi sum ASSETS LIABILITIES Total current assets Gros Fned assets Accumulated depreciation Intangbleaxeets Meninis prade Toral current liabilities 105 Toral liabilities OWNERS EQ L
For 20Y2, Macklin Inc. reported a significant increase in net income. At the end of the year, Chris Jenkins, the president, is presented with the following condensed comparative income statement: Macklin Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 $910,000 441,000 $469,000 $139,150 99,450 $238,600 $230,400 65,000 $295,400 65,000 $230,400 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Income from operations Other revenue Income before income tax Income tax expense Net income 20Y1 $700,000 350,000 $350,000 $115,000 85,000 $200,000 $150,000 50,000 $200,000 50,000 $150,000 Required: Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round percentages to one decimal place. Use the minus sign to indicate a decrease in the "Difference".columns.
Use the following Company A Balance Sheet for the next questions 8 and 9 ASSETS Cash Accounts Receivable, net Inventory Other Current Assets Property, Plant and Equipment, net Other Total Assets 1. 1. 2. 3. The Common Size entry for Inventory for Company A is: 54% 33% 18% S 16% $ LIABILITIES AND EQUITY Accounts Payable Accrued Expenses Current portion of LTD Other 1,400,000 1,600,000 1,800,000 500,000 5,300,000 20%Current Liabilities 3,700,000 Long Term Debt 1,000,000 Shareholder's Equity 10,000,000 100% Total Liabilities and Equity 1,200,000 1,500,000 300,000 400,000 3,400,000 2,800,000 3,800,000 $ 10,000,000
Q5 Revenues Cost of Goods Sold Gross Profit Selling, General and Admin Depreciation EBIT Income tax (35%) Incremental Earnings Capital Purchases Changes to NWC Year 0 Year 1 -280,0 00 Year 2 140,00 440,00 0 0 -70,00 220,00 0 0 Year 3 Year 4 440,00 350.00 0 0 220,00 175,00 0 0 70,000 220,00 220,00 0 0 -6400 6400 6400 175,00 0 6400 75.00 75.000 75,000 75,000 0 -11,40 138,60 138.60 93,600 0 0 0 3990 -48,51 48,51 0 32,76 0 0 -7410 90,090 90,090 60,840 -5.000 -5,000 -5,000 -5,000 A garage is installing a new "bubble-wash" car wash. It will promote the car wash as a fun activity for the family, and it is expected that the novelty of this approach will boost sales in the medium term. If the cost of capital is 10%, what is the net present value (NPV) of this project? Show all calculations
ff1
30
h