Developing Relevant Cash Flows. Company’s Machine Renewal or Replacement Decision
Developing Relevant Cash Flows for Part-Time Student
Company’s Machine Renewal or Replacement Decision
Mclovin, chief financial officer of Part-Time Student Company (PTSC), expects the firm’s net profits after taxes for the next 5 years to be as shown in the following table.
Year Net profits after taxes
1 $100,000
2 $150,000
3 $200,000
4 $250,000
5 $320,000
Mclovin is beginning to develop the relevant cash flows needed to analyze whether to renew or replace PTSC’s only depreciable asset, a machine that originally cost $30,000, has a current book value of zero, and can now be sold for $20,000. (Note: Because the firm’s only depreciable asset is fully depreciated---its book value is zero---its expected net profits after taxes equal its operating cash inflows.) He estimates that at the end of 5 years. Mclovin plans to use the following information to develop the relevant cash flows for each of the alternatives.
Alternative 1 Renew the existing machine at a total depreciable cost of $90,000. The renewed machine would have a 5-year usable life and depreciated under MACRS using a 5-year recovery period. Renewing the machine would result in the following projected revenues and expenses (excluding depreciation):
Year Revenue Expenses
(excluding depreciation)
1 $1,000,000 $801,500
2 1,175,000 884,200
3 1,300,000 918,100
4 1,425,000 943,100
5 1,550,000 968,100
The renewed machine would result in an increased investment of $15,000 in net working capital. At the end of 5 years, the machine could be sold to net $8,000 before taxes.
Alternative 2 Replace the existing machine with a new machine costing $100,000 and requiring installation costs of $10,000. The new machine would have a 5-year usable life and be depreciated under MACRS using a 5-year recovery period. The firm’s projected revenues and expenses (excluding depreciation), if it acquires the machine, would be as follows:
Year Revenue Expenses(excluding depreciation)
1 $1,000,000 $764,500
2 1,175,000 839,800
3 1,300,000 914,900
4 1,425,000 989,900
5 1,550,000 998,900
The new machine would result in an increased investment of $22,000 in net working capital. At the end of 5 years, the new machine could be sold to net $25,000 before taxes. The weighted average cost of capital is 10% and the marginal tax rate is 40%.
Find the NPV, IRR, MIRR, payback and discounted payback for both alternatives. Which alternative should be selected? Explain.
Professor
Course Title
Date
Company’s Machine Renewal or Replacement Decision
Net Present Value (NPV) Calculations
According to Harris et al., NPV is mainly used to conduct capital budgeting in analysis of a project profitability (11).
NPV = (Cash flows)/ (1+r) i
Where Cash flows= Cash flows in the time period, i- Initial Investment, r = Discount rate, i = time period
For the case of Part Time Student Company the NPV will be
Alternative 1
3771900170180291465017970521240751701801362075151130476250160655NPV = 100,000 + 150,000 + 200,000 + 250, 000 + 320,000 - 90,000
(1 + 0.1)1(1+0.1)2 (1+0.1)3 (1+0.1)4 (1+0.1)5
= 644585
Alternative 2
3771900170180291465017970521240751701801362075151130476250160655NPV = 100,000 + 150,000 + 200,000 + 250, 000 + 320,000 - 110,000
(1 + 0.1)1(1+0.1)2 (1+0.1)3 (1+0.1)4 (1+0.1)5
= 534,585
Calculating Internal Rate of Return
Businesses use Internal Rate of Return to estimate how profitable a given investments is. IRR is a discount that constitutes the NPV of cash flows in a project to be equal to zero. IRR is calculated using the same formula as NPV however it is equated to zero.
0=NPV=t=1∑T(1+IRR)tCt−C0
Where:
Ct=Period’s net cash inflow
tC0=Total cost of Initial Investment
IRR= internal rate of return
t= time periods
Alternative 1
37719001701802914650179705212407517018013620751511304762501606550= 100,000 + 150,000 + 200,000 + 250, 000 + 320,000 - 90,000
(1 + IRR)1(1+IRR)2 (1+IRR)3 (1+0.1)4 (1+IRR)5
The IRR is 14%
Alternative 2
37719001701802914650179705212407517018013620751511304762501606550 = 100,000 + 150,000 + 200,000 + 250, 000 + 320,000 - 110,000
(1 + IRR)1(1+IRR)2 (1+IRR)3 (1+IRR)4 (1+IRR)5
The IRR is 12%
Calculating Modified Internal Rate of Return (MIRR)
MIRR gives consideration to cost and profitability of a venture (Omokhomion, Egbu, and Robinson 19). From the variables, the formula for calculating MIRR is:
MIRR=n√ (PV (Initial outlays × Financing cost)/FVCF (Positive cash flows × Cost of capital)−1)
Where:
FVCF(c) = future value of positive cash flows at the value of capital for the firm
PVCF (fc) =present value of negative cash flows
n=number of periods
Alternative 1
FVCF = 10,000
PVCF = 15,000
N = 5
Therefore
MIRR=√ (644855(100000 x 15000)8000(10,000 x 100000)-1
= 66.40%
Al...
👀 Other Visitors are Viewing These MLA Case Study Samples:
- ACCT 302 Case Assignment Paper: The Deal for a Dozer5 pages/≈1375 words | 5 Sources | MLA | Accounting, Finance, SPSS | Case Study |
- Partial Privatization of Saudi Aramco Accounting, Finance Case Study2 pages/≈550 words | MLA | Accounting, Finance, SPSS | Case Study |
- Metropolitan Environmental Services, Inc. A Case Study in Revenue Recognition Policy4 pages/≈1100 words | 2 Sources | MLA | Accounting, Finance, SPSS | Case Study |
- Jeri Caldwell at MOEX, INC1 page/≈550 words | 1 Source | MLA | Accounting, Finance, SPSS | Case Study |
- EBAYs Report as the GAAP EPS and the Non-GAAP EPS2 pages/≈550 words | No Sources | MLA | Accounting, Finance, SPSS | Case Study |
- Accounting Control Systems Accounting, Finance, SPSS Case Study1 page/≈275 words | MLA | Accounting, Finance, SPSS | Case Study |
- Wells Fargo. Accounting, Finance, SPSS Case Study.1 page/≈275 words | MLA | Accounting, Finance, SPSS | Case Study |