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

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?
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.
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.
QUESTION 3 A company has the project cashflow presented in the table below. If the inflation-free interest rate is 12% per year and the inflation rate is 4% per year, determine the Present Worth of the company's cashflow. Cashflow Item Amount First Cost -18,000 Annual Operating Cost Salvage Value No. of Years -7500 5000 10
7 Present work in Excel Consider the following: Financed amount: $385,000 Cost of funds: 7.25% (interest rate) 30-year amortization Calculate (round to nearest dollar): Annual payment amount (this is monthly payment x 12 --- then rounded to nearest dollar) Amount of 'Interest paid' during year 3 (rounded to nearest dollar) Amount of 'Principal paid' during year 3 (rounded to nearest dollar)
10B
spreadsheet 10.1

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