Week 8 Excel Spreadsheet to be used with the Practice Set:YearsAcquisition stage cash flow:Initial OutlayOperating stage cash flow:SalesFixed CostVariable CostDepreciation expenseTaxable incomeTaxes0(800,000)12345678After tax incomeAdd back depreciationOperating cash flows600,000 600,000 600,000 600,000(220,000) (220,000) (220,000) (220,000)(240,000) (240,000) (240,000) (240,000)(68,000) (68,000) (68,000) (68,000)72,000 72,000 72,000 72,000(20,160) (20,160) (20,160) (20,160)51,840 51,840 51,84068,000 68,000 68,000119,840 119,840 119,84051,84068,000119,840600,000 600,000 600,000 600,000(220,000) (220,000) (220,000) (220,000)(240,000) (240,000) (240,000) (240,000)(68,000) (68,000) (68,000) (68,000)72,000 72,000 72,000 72,000(20,160) (20,160) (20,160) (20,160)51,840 51,840 51,840 51,84068,000 68,000 68,000 68,000119,840 119,840 119,840 119,840Disposition stage cash flow:500,000Total cash flowPresent Value(800,000)872,591119,840119,840 119,840119,840 119,840 119,840119,840 619,840Net Present Value72,591

The Week 8 Excel Spreadsheet for the Practice Set includes various financial metrics related to cash…

Answered: Week 8 Excel Spreadsheet to be used…

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- Calculate the rate of return to be obtained for the investment to be made in the 1st year according to the cash flow diagram below. year 1 4 cash flow, $ -80000 9000 70000 30000
Relevant Cash Flow Data for Year 2:Sales revenues Year 2 $100,000Cost of Goods Sold 20,000Depreciation Expense 10,000Tax Rate 40% Based on the above cash flow data: What is the operating cash flow for year two of this capital budgeting project? A.130,000 B.52,000 C.42,000 D. 78,000
Question 6 Year a. DORIAN Enterprise has developed a four-year investment plan which is expected to generate the following cash flows: 1 2 3 4 Cash flow GH¢ 30,000 45,000 48,000 50,000 The opportunity cost of capital is 18%. How much is this investment worth today? b. The financial data of DORIAN Enterprise is given as follows: Details Operating income Amount GH¢ Financial expense 275,000 47,000 Net impairment loss, gross loan portfolio 53,000 Operating expense 122,000 Gross loan portfolio 125,000 Delinquency + 1 month or more 14,000 Net subsidy 26,000 Interest rate charged on loans = 18% i. Compute the Subsidy Dependence Index (SDI) ii. Compute the Operational Self Sufficiency (OSS) iii. Compute the Portfolio at Risk (PAR) of DORIAN Ltd. iv. What do the values computed in (a), (b) and (c) represent? c. Below are the details of Accounts Receivable of DORIAN Ltd. Customer Outstanding Balance GH¢ Days outstanding 1 5,000 28 2 8,000 42 3 15,000 30 4 8,500 65 5 6,000 120 6 14,000 73 7…
Question content area top Part 1 (IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $13,000 resulting in a single free cash flow of $17,165 after 9 years b. An initial outlay of $13,000 resulting in a single free cash flow of $46,394 after 15 years c. An initial outlay of $13,000 resulting in a single free cash flow of $105,001after 25 years d. An initial outlay of $13,000 resulting in a single free cash flow of $13,653 after 4 years
Question 3 Consider the following projected cash flows (including reversion) for Property A and Property B for the following 10 years. Assume that operating cash flows (excluding reversion) = NOI, there are no capital expenditures. Annual net cash flow projections for two properties ($ millions) 1 2 3 4 5 6 7 8 9 10 A $1.0000 $1.0050 $1.0100 $1.0151 $1.0202 $1.0253 $1.0304 $1.0355 $1.0407 $12.7252 B $1.0000 $1.0200 $1.0404 $1.0612 $1.0824 $1.1041 $1.1262 $1.1487 $1.1717 $14.7395 a. What is the annual growth rate in operating cash flows for each building during the first nine years? b. If both properties sell at cap rates (initial and terminal cash yields) of 9%, what is the expected annual return (IRR) on a 10-year investment in each property?
Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of $2,100,000. Given the discount rate and the future cash flow of each project in the following table, E, what are the IRRS and MIRRS of the three projects for Quark Industries?
What is Declan's Designs' 2020 Cash Flows from Investing Activities? Question 26 options: Decrease of $22,000 Decrease of $16,000 Increase of $16,000 Increase of $22,000
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)
D Open recovered wor x✓ fx 0 A B C D E F OMEGA PROJECT CASH FLOW INFORMATION Year Inflow Outflow = Newflow 0 1 2 3 G -$225,000 -$190,000 $150,000 $190,000 $215,000 $175,000 $197,000 $70,000 $582,000 $225,000 0 $190,000 $150,000 0 $220,000 $30,000 4 $215,000 0 5 $205,000 $30,000 6 $197,000 0 7 $100,000 $30,000 Total $1,087,000 $505,000 Required ROI 18% Project Omega NPV (Year 0) Project Omega Total NPV Which of the two projects would you fund and why? ▶ 3T Company Data + Ready have on project selection? (Reference Section 2.4, pg 38-39) 19 MAY 910 30 H NPV I K L M N O ALPHA PROJECT CASH FLOW INFORMATION Year Inflow Outflow = 0 1 $50,000 2 $150,000 3 $250,000 4 $250,000 5 $200,000 6 $180,000 7 $120,000 Total $ 1,200,000 Required ROI Project Alpha NPV (Year 1). Project Alpha NPV 1 tv $300,000 $100,000 0 $50,000 0 $50,000 0 $30,000 $530,000 18% d P Newflow -$300,005 -$50,000 $150,000 $200,000 $250,000 $150,000 $180,000 $90,000 $670,000 A Q NPV
After spending $10,000 on client-development, you have just been offered a big production contract by a new client. The contract will add $200,000 to your revenues for each of the next five years and it will cost you $100,000 per year to make the additional product. You will have to use some existing equipment and buy new equipment as well. The existing equipment is fully depreciated, but could be sold for $50,000 now. If you use it in the project, it will be worthless at the end of the project. You will buy new equipment valued at $30,000 and use the 5-year MACRS schedule to depreciate it. It will be worthless at the end of the project. Your current production manager earns $80,000 per year. Since she is busy with ongoing projects, you are planning to hire an assistant at $40,000 per year to help with the expansion. You will have to immediately increase your inventory from $20,000 to $30,000. It will return to $20,000 at the end of the project. Your company's tax rate is 35% and your…
Consider the following projects cash flows: End of Year (n) Project A Project B Project C Project D -$1,000 -$3,000 $2,000 - $4,000 1 $200 $2,000 -$600 -$1,000 2 $500 $2,000 -$600 $6,000 3 $600 -$1,500 - $600 4 $400 $2,000 - $600 $2,000 Which of the following statements is correct ? Select one: a. Project A is the only simple investment b. Project A andD are the only projects that will have a unique positive rate of return c. Project B is the only non simple investment d. None of the above
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.

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS