HomeExcel File Edit ViewCPPage LayoutJ2856789101112131415161718192021222324252627282930313233Paste343536InsertXCalibri (Body)B I U vA1Ratios2 Operating profitability (OP) ratio3 Capital requirement (CR) ratio4 Return on invested capital (ROIC)Economic value added (EVA)BIfxBalance SheetTAAREDZAVCOInsert Format ToolsFormulas Data ReviewV 12VIncome StatementSelect destination and press ENTER or choose PasteDXXXXVAPR23A^ AAEV2038Data Window HelpF=XXXX280ViewGPercentage Change2039HXA_FIN Statements, CFs and Taxes_Last Name.xlsxab Wrap TextMerge & Center ✓IStatement of CFsاللهJFCFSGeneralKV♫%L500Performance Ratios.00M+Conditional FormatFormatting as Tabletv A iNSXOCellStylesPGreenwolde4Insert vDelete vFormat vQXLSX((.WERVESun Apr 23 6:58 PM8. OuSort &FilterFind &SelectSTSensitivityShareU+ 100% A1 Operating Capital2 Net operating working capital3 Long-term assets (Net FA)4 Total operating capital567 (million $)9 NOPAT8 Necessary investment in OP. Cap.10 FCFB11121314O2038XXXXXX2038203980701202020382039420540EGE 11XX600800XX12201430XX4000482010001320300035004220C1819 (million $)20 Sales21 COGS22 Depreciation23 Other expenses24 Tot. op. costs25 EBIT26 Intrest expense27 Pre-tax ernings2829 Taxes (25%)30 Net Income313233341516 Income Statement (Millions of Dollars)17Tax RateDEF20385,500450030035051503507028025%70210G203920396,0005000350420577023012011025%27.582.5لاعHLOIAssets (million $)CashBalance Sheet: Assets (Millions of Dollars)S-T investmentAccounts receivableInventoriesJTotal current assets (CA)Gross fixed assets (FA)Less: DepreciationNet FATotal assetsKLiabilities and Equity (million $)Accounts payable (A/P)Notes payableAccrualsTotal current liabilities (CL)Long-term deptTotal liabilitiesCommon StockRetained earningsTotal equityTotal L&ELMNP20383405030069080014901200173029304420493020394402503401030110021301200191031105240QRSTU

A ratio is a mathematical expression between two numerical data representing a meaningful result…

5 Operating Capital Net operating working capital Long-term assets (Net FA) Total operating capital (million $) Necessary investment in OP. Cap. NOPAT 0 FCF 1 2 3 4 8 5 6 Income Statement (Millions of Dollars) 7 (million $) Sales 1 COGS 2 Depreciation 3 Other expenses 4 Tot. op. costs 5 EBIT Intrest expense 7 Pre-tax ernings B 9 Taxes (25%) O Net Income 1 Tax Rate X X X X X 2038 2038 2038 5,500 4500 300 350 5150 350 70 280 25% 70 210 X X x X X X 2039 2039 2039 6,000 5000 350 420 5770 230 120 110 25% 27.5 82.5 Balance Sheet: Assets (Millions of Dollars) Assets (million $) Cash S-T investment Accounts receivable Inventories Total current assets (CA) Gross fixed assets (FA) Less: Depreciation Net FA Total assets Liabilities and Equity (million $) Accounts payable (A/P) Notes payable Accruals Total current liabilities (CL) Long-term dept Total liabilities Common Stock Retained earnings Total equity Total L&E 2038 80 120 420 600 1220 4000 1000 3000 4220 2038 340 50 300 690 800 1490 1200 1730 2930 4420 2039 70 20 540 800 1430 4820 1320 3500 4930 2039 440 250 340 1030 1100 2130 1200 1910 3110 5240

5 Operating Capital Net operating working capital Long-term assets (Net FA) Total operating capital (million $) Necessary investment in OP. Cap. NOPAT 0 FCF 1 2 3 4 8 5 6 Income Statement (Millions of Dollars) 7 (million $) Sales 1 COGS 2 Depreciation 3 Other expenses 4 Tot. op. costs 5 EBIT Intrest expense 7 Pre-tax ernings B 9 Taxes (25%) O Net Income 1 Tax Rate X X X X X 2038 2038 2038 5,500 4500 300 350 5150 350 70 280 25% 70 210 X X x X X X 2039 2039 2039 6,000 5000 350 420 5770 230 120 110 25% 27.5 82.5 Balance Sheet: Assets (Millions of Dollars) Assets (million $) Cash S-T investment Accounts receivable Inventories Total current assets (CA) Gross fixed assets (FA) Less: Depreciation Net FA Total assets Liabilities and Equity (million $) Accounts payable (A/P) Notes payable Accruals Total current liabilities (CL) Long-term dept Total liabilities Common Stock Retained earnings Total equity Total L&E 2038 80 120 420 600 1220 4000 1000 3000 4220 2038 340 50 300 690 800 1490 1200 1730 2930 4420 2039 70 20 540 800 1430 4820 1320 3500 4930 2039 440 250 340 1030 1100 2130 1200 1910 3110 5240

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

A. 20Y5 Annual net cash flow is incorrect. B. Present value of annual net cash flow Less investment are incorrect. a. For each year, subtract the driver salaries and operating costs from the revenues. For 20Y3 only, add the residual value. b. Multiply the present value of $1 factor for each year by that year's net cash flow (from a). Subtract the amount to be invested from the total present value of the net cash flow.
Working need
What is the annual after-tax operating cash flow? Table 3 Initial Equipment Project Life Sales Variable Costs Fixed Costs Tax rate Cost of Capital Ending Book Value Sales Price at Year 3 Net Working Capital $24,700 O $13,300 $32,250 $19,300 $55,000 3 Years $50,000 $20,000 $10,000 35% 10% $1,000 $20,000 $10,000
Year Amount $20,000/yr. 35,000/yr. 1-5 6-10 Find the present value of cash flows, assuming that the firm's opportunity cost is 14 percent. Lütfen birini seçin: a. $120,820 O b. $131,065 c. $ 14,850 d. $ 19,830
Georgetown Berbice Income before tax. 20,000 75,000Required rate of return. 12% 12%Investment 100,000 500,000 Calculate the residual income for Georgetown a. 1,500 b. 150,000 c. 15,000 d. 8,000
None
Question on ROI DATA $ Revenue 97,000 Unearned Revenue 4000 BI 5000 El Purchases Core Current Assets Land for speculation PPE Operating assets for previous year 2500 38000 58,000 75000 260,000 185,000 Operating expenses Accrued expense ТАX RATE 24000 8000 25% DEBT USED 35% INTEREST EXPENSES 14000 DEBT 86000 REAL RATE INFLATION 4% 6% RISK PREMIUM 3.5% RISK FREE RATE 10% Training cost R & D expenses $34,000 $50,000 REQUIRED 1. FIND WACC 2. CALCULATE THE EBIT AFTER TAX 3. CALCULATE COST OF EQUITY 4. CALCULATE RESIDUAL INCOME 5. CALCULATE EVA [ economic value added]
Gain on Sales of Investment 5,000.00 Adversiting Expense 8,000.00 Sales 100,000.00 less: Cost of Goods Sold 20,000.00 Other Interest Expense 2,000 Gross Profit ? Net Profit ? Operating Income ?
QUESTION 8 Calculate the Working Capital Ratio for the following: Current assets: $805,000 Current l'abilities: $1,450,000
The following information pertains to Travis Concrete: Sales revenue $2,000,000 Gross margin 700,000 100,000 550,000 Income Invested capital The company's imputed interest rate is 8%. The capital turnover is: Multiple Choice 27.50. 3.64. 20.00.
27
20. From the following data calculate: a) P/V Ratio b) Variable cost and c) Profit Rs 80,000 15,000 50,000 Sales Fixed expenses Break even point 000.00 Answer all the question PART-C 21 What are the objectives of management accoun Or b) Distinguish between management accounting a accounting. 22. From the following information calculate the b Total asset/Net worth a. = 3.5 Sales/fixed assets = 6 -