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 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
-
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...
-
As of December 31, 2013, how many deferred tax liabilities (net of deferred tax assets) did Colgate have? Please provide your answer in millions, without comma separator or decimal (Ex: 23456) Link:...
-
Generally, deductions for additions to reserves for estimated future costs (for example, an allowance for estimated warranty costs) in financial statement reporting are not allowed for Federal income...
-
Discuss what you see as the role of ethics as it pertains to management and managers. Does management, in your view, help shape the values and ethics of an organization? What about an organization's...
-
Holts method assumes an additive trend. For example, a trend of five means that the level will increase by five units per period. Suppose that there is actually a multiplicative trend. For example,...
-
a. State what is meant by the torque of a couple. b. Three strings, A, B and C, are attached to a circular ring, as shown in Figure 4.35. The strings and the ring all lie on a smooth horizontal...
-
On December 2, 2006, Pfizer Inc. announced that it was immediately discontinuing clinical trials of its Torcetrapib drug. Subsequent clinical results showed that patients taking the drug suffered a...
-
Data Back-Up Systems has obtained a $10,000, 90-day bank loan at an annual interest rate of 15%, payable at maturity. a. How much interest (in dollars) will the firm pay on the 90-day loan? b. Find...
-
Medwig Corporation has a DSO of 34 days. The company averages $2,500 in sales each day (all customers take credit). What is the company's average accounts receivable? Assume a 365-day year. Round...
-
A project has the following cash flows: Year Cash Flow -13,500 0 1 2 3 4 6,310 7,600 0 -260 Assuming the appropriate interest rate is 13%, what is the MIRR for this project using the discounting...
-
Trail Ltd s issued share capital has not changed since incorporation on 1 January 2 0 2 0 , and consists of: 4 0 0 0 0 0 Ordinary shares ( issued at R 2 each ) 1 5 0 0 0 0 9 % Preference shares (...
-
Find the mass and center of mass of the solid E with the given density function p. E lies under the plane z = 2 + x + y and above the region in the xy-plane bounded by the curves y = x, y = 0, and x...
-
This week's discussion post based on a Ted talk by Deborah Bosley in which she discussed how plain language makes life simpler and effective communication. Using plain language is valuable in...
-
You have been hired by the general manager (GM) of a budget hotel in Colorado. The hotel is part of a large economy lodging chain in North America. Economy lodging hotels include Super 8, Motel 6 and...
-
Explain the stereotypical fee structure charged by hedge fund managers; try to include all aspects that you can remember? Describe what is meant by a "13D letter", when an investor must file form...
-
Jane is an employee in a tech company. She was recently provided a contract with the terms of her compensation. She was ready to sign when an attorney contacted her and told her that her compensation...
-
Consider the function f and its graph. a. Estimate the zeros of the area function b. Estimate the points (if any) at which A has a local maximum or minimum. c. Sketch a graph of A, for 0 x 10,...
-
Market economies largely rely on a(n) _________ decision- making process, where literally millions of individual producers and consumers of goods and services determine what will be produced.
-
With no alternative use of the government purchases from a price floor, a(n) _________ will result because consumers are consuming _________ than the previous market equilibrium output and sellers...
-
Because of scarcity, certain economic questions must be answered regardless of the level of affluence of the society or its political structure. Three fundamental questions that inevitably must be...
Study smarter with the SolutionInn App