A.
Payroll Services | Tax Services |
Year | PV Factor @8% WACC | Proj A | Proj B | Proj A | Proj B |
0 | 1.0000 | (1,500,000) | (1,000,000) | (1,800,000) | (1,200,000) |
1 | 0.9259 | 700,000 | 550,000 | 900,000 | 600,000 |
2 | 0.8573 | 600,000 | 300,000 | 700,000 | 500,000 |
3 | 0.7938 | 500,000 | 300,000 | 500,000 | 400,000 |
NPV of CF | 59,468 | 4,611 | 30,387 | 101,758 |
Projects have positive CF.
B.
Payroll Services | Tax Services | |||||
Year | PV Factor @18% ROI | PV Factor @8.5% ROI | Proj A | Proj B | Proj A | Proj B |
0 | 1.0000 | 1.0000 | (1,500,000) | (1,000,000) | (1,800,000) | (1,200,000) |
1 | 0.8475 | 0.9217 | 700,000 | 550,000 | 900,000 | 600,000 |
2 | 0.7182 | 0.8495 | 600,000 | 300,000 | 700,000 | 500,000 |
3 | 0.6086 | 0.7829 | 500,000 | 300,000 | 500,000 | 400,000 |
NPV of CF @18% | (171,554) | (135,854) | ||||
NPV of CF @8.5% | 15,566 | 90,886 |
Tax Services Project have positive CF.
C. Payroll Services net profit after Tax is equal to new project investment. This department can make investment decision easily as far as initial investment is concerned. TAx Services NPAT is lower then initial investment. This department will not e able make initial investment on the basis of NPAT.
At 8% WACC, both projects have positive NPV. Hence both should invest in the project.
D. At WACC both projects have positive NPV. Hence its recommended to go for the investment. Payroll services may have higher return on existing business, but new investment will help them stay in business. Tax services will do better with this investment.
CASE 11.2 SUBOPTIMIZATION PROBLEM. Manson's Payroll Service consists of two pri- mary divisions-Payroll Services and Tax...
Case Study 3--Capital Budgeting (Comprehensive Spreadsheet Problem 11-23, page 408) Your division is considering two projects. Its WACC is 10%, and the projects' after-tax cash flows (in millions of dollars) would be as follows: Expected Cash Flows Time Project A Project B 0 ($30) ($30) 1 $5 $20 2 $10 $10 3 $15 $8 4 $20 $6 a. Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted paybacks. WACC = 10% Use Excel's NPV function as explained in NPVA...
Calculate payback periods. Please show calculations so I can
duplicate it in excel.
7 Your division is considering two projects. Its wACC is 10%, and the projects, after-tax cash flows (in millions 8 of dollars) would be as follows: Expected Cash Flows Project A Project B 10 Time (S30) S5 s10 S15 S20 (S30) S20 S10 S8 S6 12 13 14 15 16 17 18 a. Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted payback Use Excel's NPV...
Aa Aa 3. Investment timing option Decision tree and the Black-Scholes valuation Suppose a technical glitch in the trading systems in the stock markets led to several *erroneous trades. Soon after, Lesnor Co., a professional training company,came up with the idea of developing a new division that would teach securities traders to communicate by using an old style of hand language on the trading floor, which would help revive that dying language. A young product development employee, Jesse, proposed this...
Ibb Inc., a company with expertise in designing Internet-related computer software, is considering two possible capital investments. The first would require an initial investment of $1 million, but is forecast to repay $700,000 each year for two years. The second would require an initial investment of $2 million, but would repay $950,000 per year for three years. The appropriate discount rate (the required return) is 10% per year. Other than these two projects, your firm has no superior investment alternatives....
23-26: Comfy Corporation manufactures furniture in several divisions, including the patio furniture division. The manager of the patio furniture division plans to retire in two years. The manager receives a bonus based on the division’s ROI, which is currently 7%. One of the machines that the patio furniture division uses to manufacture the furniture is rather old, and the manager must decide whether to replace it. The new machine would cost $35,000 and would last 10 years. It would have...
caprai vuugtung itan Cildpel ASSighter Webmasters.com has developed a powerful new server that would be used for corporations Internet activities. It would cost $9 million at Year O to buy the equipment necessary to manufacture the server. The project would require net working capital at the beginning of each year in an amount equal to 11% of the next year's projected sales; for example, NWC = 11%4Salesı). The servers would sell for $25,000 per unit, and Webmasters believes that variable...
The Singer Division of Patio Enterprises currently earns $2.34 million and has divisional assets of $19.5 million. The division manager is considering the acquisition of a new asset that will add to profit. The investment has a cost of $3,375,000 and will have a yearly cash flow of $840,000. The asset will be depreciated using the straight-line method over a six-year life and is expected to have no salvage value. Divisional performance is measured using ROI with beginning-of-year net book...
The Singer Division of Patio Enterprises currently earns $3.92 million and has divisional assets of $24.5 million. The division manager is considering the acquisition of a new asset that will add to profit. The investment has a cost of $3,471,000 and will have a yearly cash flow of $864,000. The asset will be depreciated using the straight-line method over a six-year life and is expected to have no salvage value. Divisional performance is measured using ROI with beginning-of-year net book...
The Singer Division of Patio Enterprises currently earns $2.6 million and has divisional assets of $20 million. The division manager is considering the acquisition of a new asset that will add to profit. The investment has a cost of $3,387,000 and will have a yearly cash flow of $843,000. The asset will be depreciated using the straight-line method over a six-year life and is expected to have no salvage value. Divisional performance is measured using ROI with beginning-of-year net book...
1. Billboard, Inc. is considering a new project costing $400 million. The project cost can be depreciated on a straight-line over 20 years. Part of the cost of the project will be financed with a new bond issue. In order to finance a portion of new project, Billboard has sold for $93.54 million a twenty year, zero coupon bond with face value of $300 million. The issuance of debt will carry a one time cost at year 0 of $12.9...