Solve for Cummulative Net profit in year 5 and average LTV year 5
			YEAR
	1	2	3	4	5
REVENUES
Customers	10,000
Retention Rate	50%	55%	60%	65%	70%
Average Yearly Sales	$200	$200	$200	$200	$200
TOTAL REVENUES
COST
Cost (% of Revenues)	40%	40%	40%	40%	40%
TOTAL COSTS
PROFITS
Gross Profit
Target Interest	10%	10%	10%	10%	10%
Discount Rate
NPV Profit
CUMULATIVE NPV PROFIT
Average LTV

Download the the attached EXCEL file and solve for the Cumulative NPV profit in year 5 and average LTV for all the years. When you finish, upload the EXCEL spreadsheet. Show all your work within the spreadsheet. LIV Problem Question 3.xlsx Make sure to include your name in the file that you upload. Click "Browse" to locate your file and then click "Upload" to upload your file. Download the the attached EXCEL file and solve for the Cumulative NPV profit in year 5 and average LTV for all the years. When you finish, upload the EXCEL spreadsheet. Show all your work within the spreadsheet. LIV Problem Question 3.xlsx Make sure to include your name in the file that you upload. Click "Browse" to locate your file and then click "Upload" to upload your file