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

1. Net Operating Capital for 2022 2. Amount of Total Investor-Supplied (Net Current Investment and Net Fixed Asset Investment) operating capital for 2022 3. Free Cash Flow for 2022 Net Operating Working Capital for 2022 4. Net Operating Profit After Taxes for 2022
Encino Aluminium Company Year Cash Flow Cost of Capital 12% (75,000) 1 $ 2 $ 3 $ 18,000 18,000 18,000 4 $ 18,000 5 $ 6 $ 7 $ 18,000 18,000 18,000 24 3,000
Show formula used.
HOMEWORK-DEPRECIATION/TAXES Initial cost $400,000 $160,000 $30,000 Annual Revenue Annual Expense Recovery Period (expected life) 5 Tax Rate 30% MARR 12% 6. Construct a complete Income Statement using SL 7. Construct an Income Statement using MACRS.
Use the values in Table A-1 to complete table A-2(show formula too)
Clearcast Communications Inc. is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated operating income, and net cash flow for each proposal are as follows: Operating Income Net Cash Flow Investment Year Proposal A: $450,000 $ 30,000 1 $120,000 2 30,000 120,000 3 20,000 110,000 4 10,000 100,000 (30,000) $ 60,000 $ 60,000 40,000 60,000 $510,000 $100,000 Proposal B: $200,000 1 80,000 3 20,000 60,000 4 (10,000) 30,000 (20.000) $ 90,000 20.000 $290,000 (Continued)
Show your solutions clearly
PROGRAMS SELF DEVELOPMENT E-LIBRARY 8. 6. 10 11 12 13 14 15 16 Your company wants to invest JD 10,000,000 in network, taking into consideration the below table Investment 10,000,000.00 Lifetime Annual Revenues in Yearl 2,000,000.00 2% Annual decline in revenues from Y2 30% Direct Cost % of revenues 15% OPEX % of revenues 7% Interest Discount rate/fWACC) CO
A company is considering expanding its production line. Cost for the the equipment for the expansion: Annual incease in sales: Number of years of the project: Annual operating costs other than depreciation: The company's tax rate: There is no change in Working Capital $200,000 $125,000 3 $50,000 35% The equipment will be depreciated on a 3 year straight line basis with 0 salvage value. At the end of 3 years the equipment disposed of at no cost or sale. Calcualte the Net Free Cash Flow for years 0 and 1 only as listed below. Do not use commas, decimals, or dollar signs. Enter negative numbers with a minus sign.
Problem 1: Consider the following cash flows and assume i = 10% for all analyses purposes: Project Cash Flows A D -$2,500 -$7,000 -$5,000 -$5,000 1 $650 -$2,500 -$2,000 -$500 2 $650 -$2,000 -$2,000 -$500 $650 -$1,500 -$2,000 $4,000 4 $600 -$1,500 -$2,000 $3,000 5 $600 -$1,500 -$2,000 $3,000 $600 -$1,500 -$2,000 $2,000 7 $300 -$2,000 $3,000 8 $300 a) Compute the project balances for Projects A and D, as a function of project year b) Compute the future worth values for Projects A and D at the end of service life. c) Suppose that Projects B and C are mutually exclusive. Assume also that the required service period is eight years and that the company is considering leasing comparable equipment that has an annual lease expense of $3,000 for the remaining years of the required service period for both projects. Which project is the better choice?
Please do not give solution in image format thanku
10B