Question

Solve using a financial calculator: please show each step you use on the financial calculator!

1. Given the following information, calculate the NPV for this property. Initial cash outflow: $200,000, Discount rate: 15%, CF for year 1: $25,876, CF for year 2: $23,998, CF for year 3: $23,130, CF for year 4: $22,105, CF for year 5: $144,670. Draw your cash flow diagram and show your steps used in financial calculator.

2. Suppose you purchased an income producing property for $95,000 five years ago. In Year 1, you were able to negotiate a lease that paid $15,000 per year at the end of each year. If you are able to sell the property at the end of year 5 for $100,000 (after receiving our final lease payment), what was the internal rate of return (IRR) on this investment? Draw your cash flow diagram and show your steps used in financial calculator.

Answer 1

Answer : 1) Calculation of Net Present Value using Financial calculator :

Below is the image showing calculation of NPV :

It can be calculated on using NPV function of Financial Calculator

Cash Flow Diagram :

		+25876	+23998	+23130	+22105	+144670
Year	0	1	2	3	4	5
	-200000

2.) Calculation of IRR

		+15000	+15000	+15000	+15000	+15000	+100000
Year	0	1	2	3	4	5	5
	-95000