1. 1. In cell D10, enter a formula using the PMT function to calculate the monthly payment for a loan.
   2. Use the inputs listed under the Add 1 Location loan scenario in cells D4, D6, and D8. (Hint: The result will be displayed as a negative number to reflect the negative cash flow of a loan payment.)
2. Calculate the monthly interest rate for the Add 2 Locations scenario as follows:
   1. In cell E6, enter a formula using the RATE function to calculate the monthly interest rate for a loan.
   2. Use the inputs listed under the Add 2 Locations loan scenario in cells E8, E10, and E4. (Hint: Assume the present value of the loan is the loan amount shown in cell E4.)
3. Calculate the loan amount for the Add 3 Locations scenario as follows:
   1. In cell F4, enter a formula using the PV function to calculate the loan amount.

	Conditions		Add 1 Location	Add 2 Locations	Add 3 Locations	Merger
	Loan amount		$103,000	$166,000		$450,000
	Annual interest rate		5.00%	0.00%	4.50%	5.00%
	Monthly interest rate		0.48%		0.44%	0.50%
	Loan period in years		5	6	8	0.0
	Loan period in months		60	72	96
	Start date of loan		1/2/2019	1/2/2019	1/2/2019	1/2/2019
	Monthly Payment Due			($2,700)	($3,700)	($5,000)