EXCEL WORKSHEET. I need help with formulas for missing information.

Input Area			Summary Calculations
Complex Cost	$950,000.00		Loan Amount
Down Payment	$400,000.00		No. Periods
# of Pmts per Year	12		Monthly Rate
Years	30		Monthly Payment
APR	5.325%		Total Interest Paid
1st Payment Date	1/20/2017
Payment #	Payment Date	Beginning Balance	Interest Paid	Principal Payment	Ending Balance
1	1/20/2017
2	2/20/2017
3	3/20/2017
4	4/20/2017
5	5/20/2017
6	6/20/2017
7	7/20/2017
8	8/20/2017
9	9/20/2017
10	10/20/2017
11	11/20/2017
12	12/20/2017
13	1/20/2018
14	2/20/2018
15	3/20/2018
16	4/20/2018
17	5/20/2018
18	6/20/2018
19	7/20/2018
20	8/20/2018
21	9/20/2018
22	10/20/2018
23	11/20/2018
24	12/20/2018
25	1/20/2019
26	2/20/2019
27	3/20/2019
28	4/20/2019
29	5/20/2019
30	6/20/2019
31	7/20/2019
32	8/20/2019
33	9/20/2019
34	10/20/2019
35	11/20/2019
36	12/20/2019
37	1/20/2020
38	2/20/2020
39	3/20/2020
40	4/20/2020
41	5/20/2020
42	6/20/2020
43	7/20/2020
44	8/20/2020

10:51 Contents 12/ Summit Ridge Ski owners want to purchase a sixth apartment complex. This decision is under review. Here are the details of their offer. The loan amount is $950,000 with a down payment of $400,000 for 30 years at 5.325%, with the first payment due on January 20, 2017. Please consider the loan calculations and build a loan amortization table on the Loan worksheet. Click on the Loan worksheet to begin. A. Enter the loan details provided above in the Input Area and place formulas to create all calculations in the Summary Calculations. The loan payment is at the end of the period B. Create a loan amortization table. The Payment Date column needs a date function. The Interest Paid and Principal Payment columns require financial functions C. Create a custom footer with your name on the left side, the page and page number in the center, and your professor's name on the right side of each worksheet. Make sure you put the page back to normal view after you insert the footer at the bottom