Using functions , complete the “Aggregated Data” worksheet using the “Statementof Income” worksheet. Financial Aggregated Data20192020Average RevenueLargest ExpensesLowest RevenuesSmallest Expenses# of Expense components# of Revenue components Living Large FinanceCOMPARITIVE INCOME STATEMENTfor years ended 31 December20192020Revenues and gains*Sales revenue$516,500 $278,500 $77,900 $101,500 $974,400 $903,875487,375136,325177,625*Interest revenue$*Investment Income$*Other revenue$Total revenue and gains$1,705,200Expenses and losses**Cost of goods sold**Selling and admin administrative $***Computer (operating)**Depreciation**Interest expense$475,000 $175,000 $712,500262,50064,05076,50045,6001,161,150544,050$42,700 $51,000 $30,400 $774,100 $$$Total expenses and lossesIncome before taxesIncome tax expense (30%)2$200,300 $60,090 $140,210 $$163,215Net Income$380,835

Functions in excel are of great importance as it minimizes the required efforts which are to be put…

COMPARITIVE INCOME STATEMENT for years ended 31 December 2019 2020 Revenues and gains *Sales revenue $ 516,500 $ 278,500 $ 77,900 $ 101,500 $ 974,400 $ 1,705,200 903,875 487,375 136,325 177,625 "Interest revenue "Investment Income $ $ "Other revenue $ Total revenue and gains $ Expenses and losses *"Cost of goods sold **Selling and admin administrative $ ***Computer (operating) *"Depreciation *"Interest expense Total expenses and losses Income before taxes $ 475,000 $ 175,000 $ 42,700 $ 51,000 $ 30,400 $ 774,100 $ 712,500 262,500 64,050 76,500 45,600 1,161,150 544,050 163,215 380,835 $ $ $ $ 200,300 $ $ $ Income tax expense (30%) 60,090 $ 140,210 $ Net Income $

COMPARITIVE INCOME STATEMENT for years ended 31 December 2019 2020 Revenues and gains Sales revenue $ 516,500 $ 278,500 $ 77,900 $ 101,500 $ 974,400 $ 1,705,200 903,875 487,375 136,325 177,625 "Interest revenue "Investment Income $ $ "Other revenue $ Total revenue and gains $ Expenses and losses "Cost of goods sold Selling and admin administrative $ Computer (operating) "Depreciation *"Interest expense Total expenses and losses Income before taxes $ 475,000 $ 175,000 $ 42,700 $ 51,000 $ 30,400 $ 774,100 $ 712,500 262,500 64,050 76,500 45,600 1,161,150 544,050 163,215 380,835 $ $ $ $ 200,300 $ $ $ Income tax expense (30%) 60,090 $ 140,210 $ Net Income $

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter15: Capital Investment Analysis

Section: Chapter Questions

Problem 15.2.1MBA

See similar textbooks

Similar questions

Question 10 of 25 Based on the following data, what is the amount of working capital? Accounts payable Accounts receivable Cash Intangible assets Inventory Long-term investments Long-term liabilities Short-term investments Notes payable (short-term) Property, plant, and equipment Prepaid insurance $404240 O $411680 > O $458800 $79360 141360 86800 124000 171120 198400 248000 99200 69440 1661600 2480
Year Net Cash Flow Discount Factor Present Value (using the factor) Present Value (using Excel formula) 0 $ (3,500,000.00) 1 $ (3,500,000.00) ($3,500,000.00) 1 $ 900,000.00 0.90909 $ 818,181.00 $818,181.82 2 $ 900,000.00 0.82645 $ 743,805.00 $743,801.65 3 $ 900,000.00 0.75131 $ 676,179.00 $676,183.32 4 $ 900,000.00 0.68301 $ 614,709.00 $614,712.11 5 $ 900,000.00 0.62092 $ 558,828.00 $558,829.19 Net Present Value $ (88,298.00) $ (88,291.91) 3. Now assume that inflation is estimated as a 5% increase each year (starting with Year 1) for the entire 5 years. Calculate the new net cash flow values for each year. start with 5% increase for Year 1 net cash flow. Year Net Cash Flow 0 $…
Year Net Cash Flow Discount Factor Present Value (using the factor) Present Value (using Excel formula) 0 $ (3,500,000.00) 1 $(3,500,000.00) ($3,500,000.00) 1 $900,000.00 0.90909 $818, 181.00 $818, 181.82 2 $ 900,000.00 0.82645 $743,805.00 $743, 801.65 3 $900,000.00 0.75131 $676, 179.00 $676, 183.32 4 $ 900,000.00 0.68301 $614,709.00 $614,712.11 5 $900,000.00 0.62092 $558, 828.00 $558,829.19 Net Present Value $(88,298.00) $(88,291.91) 3. Now assume that inflation is estimated as a 5% increase each year (starting with Year 1) for the entire 5 years. Calculate the new net cash flow values for each year. Hint: You should start with 5% increase for Year 1 net cash flow.
Cash Short-term investments Receivables (net) Inventory Total current liabilities (a) December 31, 2020 $40,400 20,300 113,375 78,070 105,500 Current ratio December 31, 2019 $32,700 18,400 During 2020, net sales were $1,441,125, and cost of goods sold was $1,091,775. :1 92,500 67,500 91,500 Compute the current ratio at December 31, 2020. (Round answer to 2 decimal places, e.g. 15.25.)
Profits. What are the profits on the following investments, E? Enter a negative number for a loss. ..... Original Cost of Investment Selling Price of Investment Distributions Investment Received Dollar Profit/(Loss) CD $800 $860 $0 (Round to the nearest dollar.)
Sales Costs Taxable Income Taxes Net Income Retained Earnings Dividends Lizard & Co. Balance Sheet ($ in millions) Assets Current Assets Cash Accounts Receiv. Inventory Total Current Net Fixed Assets Net PP&E Total Assets Year 1 420 360 60 20 40 40 10 Year 1 20 52 120 192 160 352 Year 2 525 450 75 25 50 50 12.5 Year 2 Current Liabilities 25 Accounts Payable 65 Notes Payable 150 Total 240 Long Term Debt 440 Growth Rate +25% 200 Owners Equity Common Stock Retained Earnings Total Total Liabilities/Equity Year 1 30 40 70 80 112 90 202 352 Year 2 30 40 70 80 112 90+50 252 402
Partial Income Statement Excel Exercise Compute the Following ՀԱՐ Sales COGS SG&A Depreciation Debt Int. Rate Tax Rate* 2019 100 40 EBITDA EBIT 25 Interest 10 EBT 0.08 Tax 0.25 Net Income ? ? ? ? ? ? Partial Balance Sheet Debt and Loans 150 Total Equity 150 Total Assets 300 Inv. Change 10 A/R Change A/P Change 35 20 Net Profit Margin Equity Multiplier Verify Dupont ROE ? סיי ? ? ? ? ? * Assume all taxes paid in current period (no accrued taxes) for rest of course CF from Operations ROE Asset Turnover CED Tt O 24
Income Statement for the years ending 31 August: 2020 2019 £ £Revenue 950,000 975,000Cost of sales 455,000 460,000Gross profit 495,000 515,000Total expenses 320,000 310,000Net profit 175,000 205,000 Statement of financial position as at 31 August: 2020 2019£ £Non-current assets 70,000 65,000Current assetsCash at bank…
Data needed: SFP Asset section 1. Cash 16.3% 2. AR 6.3% 3. Short term investment 0.2% 4. Inventory 2.2% 5. Prepaid expenses 0.4% 6. PPE 74.7% Data needed: SFP Liabilities and OE section. 1. Current liab 16% 2. Non-current liab 34.2% 3. OE 49.9% Data needed: SCI 1. COGS 38.6% 2. Selling and admin exp 6.8% 3. Interest exp 0.1% 4. Income tax exp 0.5% 5. Net income 54%
Melissa Jucarez u/22/2021 Corporate finance TRB Of the fallowing see of ccsh flous? Year what 19 the COsh Flows -18.700 1 9,400 10,400 3 6is00
Income Statement for the years ending 31 August: 2020 2019 £ £Revenue 950,000 975,000Cost of sales 455,000 460,000Gross profit 495,000 515,000Total expenses 320,000 310,000Net profit 175,000 205,000 Statement of financial position as at 31 August:- 2020 2019£ £Non-current assets 70,000 65,000Current assetsCash at bank…
Harlan Mining Co. has recently decided to go public and has hired you as an independent CPA. One statement that the enterprise is anxious to have prepared is a statement of cash flows. Financial statements for 2025 are provided below. Cash COMPARATIVE BALANCE SHEETS Accounts receivable Inventory Property, plant, and equipment Less accumulated depreciation Accounts payable Income taxes payable Bonds payable Common stock Retained earnings 12/31/25 $608000 (320000) $408000 360000 384000 288000 $1440000 $176000 352000 360000 216000 336000 $1440000 INCOME STATEMENT For the Year Ended December 31, 2025 12/31/24 $960000 (304000) $192000 216000 480000 656000 $1544000 $96000 392000 600000 216000 240000 $1544000