In: Accounting
Assume ABC Company has asked you to not only prepare their 2017 year-end Balance Sheet but to also provide pro-forma financial statements for 2018. In addition, they have asked you to evaluate their company based on the pro-forma statements with regard to ratios. They also want you to evaluate 3 projects they are considering. Their information is as follows:
End of the year information:
Account |
12/31/17 Ending Balance |
Cash |
50,000 |
Accounts Receivable |
175,000 |
Inventory |
126,000 |
Equipment |
480,000 |
Accumulated Depreciation |
90,000 |
Accounts Payable |
156,000 |
Short-term Notes Payable |
12,000 |
Long-term Notes Payable |
200,000 |
Common Stock |
235,000 |
Retained Earnings |
solve |
Additional Information:
ABC Company’s management is also considering 3 new projects consisting of the purchase of new equipment. The company has limited resources, and may not be able to complete make all 3 purchases. The information is as follows for the purchases below.
Project 1 |
Project 2 |
Project 3 |
|
Purchase Price |
$80,000 |
$175,000 |
$22,700 |
Required Rate of Return |
6% |
8% |
12% |
Time Period |
3 years |
5 years |
2 years |
Cash Flows – Year 1 |
$48,000 |
$85,000 |
$13,000 |
Cash Flows – Year 2 |
$36,000 |
$74,000 |
$13,000 |
Cash Flows – Year 3 |
$22,000 |
$38,000 |
N/A |
Cash Flows – Year 4 |
N/A |
$26,800 |
N/A |
Cash Flows – Year 5 |
N/A |
$19,000 |
N/A |
Required Action:
Part A:
Part B:
Provide justification and analysis as to why you chose the order you did. The analysis must also be done in Excel, not in a separate document.
(PART: B)
NPV (Net Present Value) = Sum of Discounted cash inflows- Sum of Discounted cash out Flows
COMPUTATION OF NPV OF PROJECTS:
NPV of Project: 1 |
|||
Year |
Cashflows |
Required rate of return @ 6% |
Discounted Cashflows |
1 |
$48,000.00 |
0.9434 |
$45,283.02 |
2 |
$36,000.00 |
0.8900 |
$32,039.87 |
3 |
$22,000.00 |
0.8396 |
$18,471.62 |
4 |
$0.00 |
0.7921 |
$0.00 |
5 |
$0.00 |
0.7473 |
$0.00 |
Discounted Cashflows |
$95,794.51 |
||
Discounted Cash Outflows |
$80,000.00 |
||
NPV |
$15,794.51 |
NPV of Project: 2 |
|||
Year |
Cashflows |
Required rate of return @ 8% |
Discounted Cashflows |
1 |
$85,000.00 |
0.9259 |
$78,703.70 |
2 |
$74,000.00 |
0.8573 |
$63,443.07 |
3 |
$38,000.00 |
0.7938 |
$30,165.63 |
4 |
$26,800.00 |
0.7350 |
$19,698.80 |
5 |
$19,000.00 |
0.6806 |
$12,931.08 |
Discounted Cashflows |
$2,04,942.28 |
||
Discounted Cash Outflows |
$1,75,000.00 |
||
NPV |
$29,942.28 |
NPV of Project: 3 |
|||
Year |
Cashflows |
Required rate of return @ 12% |
Discounted Cashflows |
1 |
$13,000.00 |
0.8929 |
$11,607.14 |
2 |
$13,000.00 |
0.7972 |
$10,363.52 |
3 |
$0.00 |
0.0000 |
$0.00 |
4 |
$0.00 |
0.0000 |
$0.00 |
5 |
$0.00 |
0.0000 |
$0.00 |
Discounted Cashflows |
$21,970.66 |
||
Discounted Cash Outflows |
$22,700.00 |
||
NPV |
-$729.34 |
Here, Project-1 and Project -2 have positive NPV's. Project-3 has Negative NPV.
Hence Project -3 should be Rejected.
Only Project-1 and Project -2 should be accepted.
In order to determine which project should be completed first, we need to do capital rationing.
CAPITAL RATIONING: Whenever there is scarcity of the amount of funds that can be invested during the specific period of time then we should do capital rationing.
If our objective is maximisation of profits, then use NPV method. But here our objective is maximum utilisation of fund, then we should use profitability index.
PROFITABILITY INDEX = Discounted Cash inflows/ Discounted Cash outflows
Profitability Index |
|||
Project |
Discounted Cash inflows |
Discounted Cash Outflows |
PI=D.Cash inflows/D.Cash Outflows |
Project-1 |
$95,794.51 |
$80,000.00 |
1.20 |
Project-2 |
$2,04,942.28 |
$1,75,000.00 |
1.17 |
So, Project -2 has higher PI, It should be completed First. Then only Project -1 Should be started.
So, Project -2 has higher PI, It should be completed First. Then only Project -1 Should be started.