In: Economics
Please solve it within 20 minutes (updated)
a)
The cash flows associated with the purchase of the machine is shown in the following table
The cash flow diagram can be drawn using excel. In excel, go to insert, chart and select column.
------------------------------------------------------------------------------------------------------------
b)
The value of the investment at the end of 5 years is found as folllows
Future value = Present value ( 1 + interest rate ) n
Future value = $ 5000 ( 1 + 0.05 ) 5
Future value = $ 6381.4
The cash flows is shown in the following table
To insert the cash flow diagram in excel, choose insert, charts , select the data and choose column.