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:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66466a6269268_78666466a62296e7.jpg)
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 Growth Rate WACC Beta 4 $ 385,000.00 $ 129,000.00 $ 20,000.00 S 30,000.00 $ 391,200.00 46.0% 21.0% 7.0% 6.68% 1.25 Note Cells C17 and C18 include the initial cash flows today. Column D through G are 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 Total Debt Total Value Spreadsheet for determining Cash Flows (in Thousands) Timeline: II. Net Investment Outlay = Initial CFs Price Increase in NWC III. Cash Flows from Operations Total Revenues Variable Costs Fixed Costs Depreciation 0 Year 2 3 $ 385,000.00 $25,000.00 Re Rd Tax Rate 21.0% WACC Earnings Before Taxes Taxes $ 385,000.00 $ 177,100.00 S $ 129,000.00 $ $ 96,250.00 $ $ (17,350.00) $ ($3,643.50) Net Income Depreciation IV. Terminal Cash Flows Salvage Value Tax on Salvage Value Return of NWC Cash Flows Present Value of CFs $ (20,993.50) $ $ 96,250.00 $ Net operating CFs $ 75,256.50 S $411,950.00 189,497.00 $ 129,000.00 $ 96,250.00 $ (2,797.00) $ ($587.37) (3,384.37) $ 96,250.00 $ 92.865.63 $ $440,786.50 202.761.79 $ 129,000.00 $ 96,250.00 S 12.774.71 S $2,682.69 10,092.02 $ 96,250.00 S 106.342.02 $ $471,641.56 $504,656.46 216,955.12 $ 232,141.97 129,000.00 $ 129,000.00 96,250.00 S 96,250.00 29,436.44 $ 47,264.49 $6,181.65 $9,925.54 23,254.79 $ 37,338.95 96,250.00 $ 96,250.00 119,504,79 $ 133,588.95 Cost of Debt N Periods Y PMT PV FV Cost of Equity $ 20,000.00 $4,200.00 Risk Free Rate Market Risk Premium Beta CAPM: $25,000.00 Calculate: NPV NPV Decision: Accept? Reject? % #DIV/0 #DIVIO 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 Growth Rate WACC Beta 4 $ 385,000.00 $ 129,000.00 $ 20,000.00 S 30,000.00 $ 391,200.00 46.0% 21.0% 7.0% 6.68% 1.25 Note Cells C17 and C18 include the initial cash flows today. Column D through G are 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 Total Debt Total Value Spreadsheet for determining Cash Flows (in Thousands) Timeline: II. Net Investment Outlay = Initial CFs Price Increase in NWC III. Cash Flows from Operations Total Revenues Variable Costs Fixed Costs Depreciation 0 Year 2 3 $ 385,000.00 $25,000.00 Re Rd Tax Rate 21.0% WACC Earnings Before Taxes Taxes $ 385,000.00 $ 177,100.00 S $ 129,000.00 $ $ 96,250.00 $ $ (17,350.00) $ ($3,643.50) Net Income Depreciation IV. Terminal Cash Flows Salvage Value Tax on Salvage Value Return of NWC Cash Flows Present Value of CFs $ (20,993.50) $ $ 96,250.00 $ Net operating CFs $ 75,256.50 S $411,950.00 189,497.00 $ 129,000.00 $ 96,250.00 $ (2,797.00) $ ($587.37) (3,384.37) $ 96,250.00 $ 92.865.63 $ $440,786.50 202.761.79 $ 129,000.00 $ 96,250.00 S 12.774.71 S $2,682.69 10,092.02 $ 96,250.00 S 106.342.02 $ $471,641.56 $504,656.46 216,955.12 $ 232,141.97 129,000.00 $ 129,000.00 96,250.00 S 96,250.00 29,436.44 $ 47,264.49 $6,181.65 $9,925.54 23,254.79 $ 37,338.95 96,250.00 $ 96,250.00 119,504,79 $ 133,588.95 Cost of Debt N Periods Y PMT PV FV Cost of Equity $ 20,000.00 $4,200.00 Risk Free Rate Market Risk Premium Beta CAPM: $25,000.00 Calculate: NPV NPV Decision: Accept? Reject? % #DIV/0 #DIVIO
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Find the eccentricity of the hyperbola. Then find and graph the hyperbolas foci and directrices. x 2 - y 2 = 1
-
What is discounting? Give an illustration.
-
Where does majority of rhe cask of amontillado take place?
-
Is it a good idea for a board to use application forms as a recruitment method?
-
Tony and Suzie are ready to expand Great Adventures even further in 2016. Tony believes that many groups in the community (for example, Boy Scouts, church groups, civic groups, and local businesses)...
-
What are the differences between manager and leadership? Please explain.
-
Let f(x) = x+7x+12 and g(x) = x-9. A. Find (f*g)(x). B. Find (4)(x).
-
Use the following information from a coffee shop for 1 year to calculate the inventory turnover (round to 3 decimal points, i.e. .123). Category Number Beverage Revenue $1,380,000 Food Revenue...
-
What are financial implications? Describe how a healthcare facility would monitor financial implications after the implementation of telehealth services and privacy consideration performance...
-
K Given the information below, estimate the probability that the noncritical path B-C-G will take more than 15 weeks. Hint Subtract from 1.0 the probability that B-C-G will take 15 weeks or less....
-
Central Perk has a cycle of 3 days, and uses a Raw and In-process (RIP) account and charges all conversion costs to Cost of Goods Sold (COGS). At the end of each month, all inventories are counted,...
-
The following questions satisfies the Analytical Skills outcome (b2) Count the number of basic operations, calculate the running time, trace and find the output of the following segment of code (5...
-
A perfectly competitive firm produces two goods, X and Y, which are sold at 24 and 22 per unit, respectively. The firm has a total cost function given by TC=3x+3xy+2y-100 Calculate the expression of...
-
Ask students to outline the reasons why the various elements of culture (social structures and control systems, language and aesthetics, religion and other belief systems, educational systems, etc.)...
-
Sometimes total spending is excessive, and _________ occurs.
-
Sometimes total spending is insufficient, and _________ occurs.
-
In the case of market _________, appropriate government policies could improve on market outcomes.
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App