Using the project management case study,Calculate the Net Present Value (NPV) for the project...

Question

Using the project management case study,Calculate the Net Present Value (NPV) for the project business case. (Use Microsoft Excel to derive the NPV assuming the data below—submit an Excel spreadsheet as an appendix:Purchase price of $400,000.One-time project costs total of $100,000 spent in Year 0.Net benefits after taxes of $150,000 per year for five years.Salvage value for Year 6 and beyond of $400,000.)Summarize your results of NPV in the paper and refer to the Appendix.

Ashish · Accepted Answer

Sheet1
	Solution-
		Assume Rate of Interest:
		Interest Rate	8%	10%
		Year	Cash Inflows	Cash Inflows
		0	($500,000)	($500,000)
		1	$150,000	$150,000
		2	$150,000	$150,000
		3	$150,000	$150,000
		4	$150,000	$150,000
		5	$150,000	$150,000
		Salvage Value	$400,000	$400,000
		NPV	$350,974.

Using the project management case study, Calculate the Net Present Value (NPV) for the project business case. (Use Microsoft Excel to derive the NPV assuming the data below—submit an Excel spreadsheet...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment