Final Case Project I. Given the following data on proposed capital budgeting project. Economic life of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Final Case Project I. Given the following data on proposed capital budgeting project. Economic life of project in years. Price of New Equipment Fixed Costs Salvage value of New Equipment Effect on NWC: First Year Revenues Variable Costs Marginal Tax Rate 10 11 Growth Rate Note Cells C17 and C18 include the initial cash flows today. Column D through Gare the operating cash flows. Cells D30, D31, and D32 include terminal cash flows. PLEASE NOTE: You may need to change inputs provided in Column E at left. WACC Total Equity WACC Beta Total Debt Total Value $ Re 0 1 2 3 4 Rd 14 Spreadsheet for determining Cash Flows (in Thousands) 15 Timeline: 16 II. Net Investment Outlay = Initial CFs Price Increase in NWC 19 III. Cash Flows from Operations 20 -2345678922231562222222222222333333333 Total Revenues Variable Costs Fixed Costs Depreciation Earnings Before Taxes Taxes Net Income Depreciation Net operating CFs 29 IV. Terminal Cash Flows Salvage Value 30 36 Calculate: Tax on Salvage Value Return of NWC Cash Flows Present Value of CFs NPV Decision: NPV Year Accept? Reject? Tax Rate WACC: Cost of Debt N Periods I/Y PMT PV FV Cost of Equity Risk Free Rate Market Risk Premium Beta CAPM: 40 A B C D 1 Creating a NPV Profile (Most Likely Scenario) 2 Discount Rate: 0% PV(CF) 2% PV(CF) 3 Year CF 4 0 $ 5 1 $ 6 2 $ 7 3 $ 8 4 $ 9 NPV 10 Discount Rate: 11 $ % #DIV/0! #DIV/O! E F G H J K L M N P Q R S Create a NPV by creating a line graph of rows 9 and 10. 4% PV(CF) 6% PV(CF) 8% PV(CF) 0% 2% 4% 6% 8% Cells B4 to B8 in this worksheet can link to cells C32 to G32 in the Blank Template worksheet. Find the present value of cash flows by referencing row 2 for the discount rate. You can do column C the same way as you did C33 to G33 in the Blank Template worksheet. Rows 9 & 10 are the table that are used to create the NPV profile graph. Final Case Project I. Given the following data on proposed capital budgeting project. Economic life of project in years. Price of New Equipment Fixed Costs Salvage value of New Equipment Effect on NWC: First Year Revenues Variable Costs Marginal Tax Rate 10 11 Growth Rate Note Cells C17 and C18 include the initial cash flows today. Column D through Gare the operating cash flows. Cells D30, D31, and D32 include terminal cash flows. PLEASE NOTE: You may need to change inputs provided in Column E at left. WACC Total Equity WACC Beta Total Debt Total Value $ Re 0 1 2 3 4 Rd 14 Spreadsheet for determining Cash Flows (in Thousands) 15 Timeline: 16 II. Net Investment Outlay = Initial CFs Price Increase in NWC 19 III. Cash Flows from Operations 20 -2345678922231562222222222222333333333 Total Revenues Variable Costs Fixed Costs Depreciation Earnings Before Taxes Taxes Net Income Depreciation Net operating CFs 29 IV. Terminal Cash Flows Salvage Value 30 36 Calculate: Tax on Salvage Value Return of NWC Cash Flows Present Value of CFs NPV Decision: NPV Year Accept? Reject? Tax Rate WACC: Cost of Debt N Periods I/Y PMT PV FV Cost of Equity Risk Free Rate Market Risk Premium Beta CAPM: 40 A B C D 1 Creating a NPV Profile (Most Likely Scenario) 2 Discount Rate: 0% PV(CF) 2% PV(CF) 3 Year CF 4 0 $ 5 1 $ 6 2 $ 7 3 $ 8 4 $ 9 NPV 10 Discount Rate: 11 $ % #DIV/0! #DIV/O! E F G H J K L M N P Q R S Create a NPV by creating a line graph of rows 9 and 10. 4% PV(CF) 6% PV(CF) 8% PV(CF) 0% 2% 4% 6% 8% Cells B4 to B8 in this worksheet can link to cells C32 to G32 in the Blank Template worksheet. Find the present value of cash flows by referencing row 2 for the discount rate. You can do column C the same way as you did C33 to G33 in the Blank Template worksheet. Rows 9 & 10 are the table that are used to create the NPV profile graph.
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 9781260193275
12th Canadian Edition
Authors: Ray H. Garrison, Alan Webb, Theresa Libby
Posted Date:
Students also viewed these accounting questions
-
I want you to take a moment and calculate how much you spend on buying food that is unhealthy, or if you can get a Project: Do you think you could save about half a million dollars by not frequently...
-
CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...
-
Assignment Description The final assignment for MBA 675 is to demonstrate one's understanding of the importance of the operations of a firm through an examination of the firm's operations strategy...
-
East Corp is a mature company and expects its sales and operating costs to be fixed (or unchanged) in perpetuity. It has sales of $524,000 and operating costs of $272,480. The firm has a tax rate of...
-
Expand the momentgenerating function of the gamma distribution as a binomial series, and read off the values of '1, '2, '3, and '4.
-
Explain relationships between the Toxic Substances Control Act (TSCA) and the Federal Insecticide, Fungicide, and Rodenticide Act (FIFRA).
-
Alberts Trip to Canada. Albert visits Toronto and buys 1.74 Canadian dollars (CAD) for one British pound (GBP). When he returns home to the U.K., he converts CAD1 into GBP0.59. Is the new exchange...
-
Flow of gas through a packed column, a horizontal tube with diameter 4 in. and length 5.5 ft is packed with glass spheres of diameter 1/16 in., and the void fraction is 0.41. Carbon dioxide is to be...
-
Orleans, Inc. was incorporated on January 1, 2014. Orleans issued 5000 shares of common stock and 800, $8 shares of cumulative preferred stock on that date. Orleans has not paid any dividends yet. In...
-
I need help, Whats a TRAAP method A brief review of each piece of evidence in your portfolio using several criteria from the TRAAP MethodLinks to an external site. to determine its credibility
-
CompanyA plans to start tracking individual steps and costs in the journey of products that are shipped from foreign countries / regions . CompanyB in a foreign country / region requires CompanyA to...
-
What strategic controls and what financial controls could be used for a music streaming service?
-
Using Ruby on Rails, develop web application that allows users to share inspirational thoughts with others. There is a single model: Inspirations. Each inspiration consists of a string, the number of...
-
What are the most effective strategies for addressing transboundary environmental issues, such as deforestation and ocean pollution?
-
If the government would like to maintain the same growth trajectory for the economy, which of the policy types below should it implement?
-
How can businesses effectively manage and optimize their product life cycle to maximize profitability?
-
Why is homeostasis defined as the "relative constancy of the internal environments? Does negative feedback or positive feedback tend to promote homeostasis?
-
What is this project's discounted payback period? (10 points) a. 3.04 b. 3.24 c. 3.44 d. 3.64 Assume that the appropriate cost of capital for this project is 12 percent. Time 0 1 Cash Flow -$750 $400...
-
What is this project's IRR? a. 25.67% b. 27.19% c. 28.76% d. 29.86% Assume that the appropriate cost of capital for this project is 12 percent. 0 1 2 Time Cash Flow -$750 $400 $300 3 $200 4 $400
-
What is this project's Modified IRR (MIRR)? a. 18.78% b. 19.65% c. 20.14% d. 21.37% Assume that the appropriate cost of capital for this project is 12 percent. Time Cash Flow 0 1 -$750 $400 $300 2 3...
Study smarter with the SolutionInn App