Question

On the second tab build the full amortization table for a 15 year Constant Amortizing Mortgage (CAM) Loan with a 6% interest rate compounded monthly. The initial loan amount should be $7,500,000. in excel

Answer 1

	PV =	Loan Amount
	r =	rate of interest
	n =	no of periods
	P =	r (PV)
		1 - (1 + r )-n
	P =	(6%/12)*750000
		1 - (1 / (1 + 6%/12)^180))
	P =	3750
		0.592517573
	P =	6328.93
	Beginning Balance	Interest	Principal	Ending Balance
1	$750,000.00	$3,750.00	$2,578.93	$747,421.07
2	$747,421.07	$3,737.11	$2,591.82	$744,829.25
3	$744,829.25	$3,724.15	$2,604.78	$742,224.47
4	$742,224.47	$3,711.12	$2,617.80	$739,606.67
5	$739,606.67	$3,698.03	$2,630.89	$736,975.78
6	$736,975.78	$3,684.88	$2,644.05	$734,331.73
7	$734,331.73	$3,671.66	$2,657.27	$731,674.46
8	$731,674.46	$3,658.37	$2,670.55	$729,003.91
9	$729,003.91	$3,645.02	$2,683.91	$726,320.00
10	$726,320.00	$3,631.60	$2,697.33	$723,622.67
11	$723,622.67	$3,618.11	$2,710.81	$720,911.86
12	$720,911.86	$3,604.56	$2,724.37	$718,187.49
Year #1 End
13	$718,187.49	$3,590.94	$2,737.99	$715,449.51
14	$715,449.51	$3,577.25	$2,751.68	$712,697.83
15	$712,697.83	$3,563.49	$2,765.44	$709,932.39
16	$709,932.39	$3,549.66	$2,779.26	$707,153.13
17	$707,153.13	$3,535.77	$2,793.16	$704,359.97
18	$704,359.97	$3,521.80	$2,807.13	$701,552.84
19	$701,552.84	$3,507.76	$2,821.16	$698,731.68
20	$698,731.68	$3,493.66	$2,835.27	$695,896.41
21	$695,896.41	$3,479.48	$2,849.44	$693,046.97
22	$693,046.97	$3,465.23	$2,863.69	$690,183.27
23	$690,183.27	$3,450.92	$2,878.01	$687,305.26
24	$687,305.26	$3,436.53	$2,892.40	$684,412.86
Year #2 End
25	$684,412.86	$3,422.06	$2,906.86	$681,506.00
26	$681,506.00	$3,407.53	$2,921.40	$678,584.61
27	$678,584.61	$3,392.92	$2,936.00	$675,648.60
28	$675,648.60	$3,378.24	$2,950.68	$672,697.92
29	$672,697.92	$3,363.49	$2,965.44	$669,732.48
30	$669,732.48	$3,348.66	$2,980.26	$666,752.22
31	$666,752.22	$3,333.76	$2,995.17	$663,757.05
32	$663,757.05	$3,318.79	$3,010.14	$660,746.91
33	$660,746.91	$3,303.73	$3,025.19	$657,721.72
34	$657,721.72	$3,288.61	$3,040.32	$654,681.40
35	$654,681.40	$3,273.41	$3,055.52	$651,625.88
36	$651,625.88	$3,258.13	$3,070.80	$648,555.09
Year #3 End
37	$648,555.09	$3,242.78	$3,086.15	$645,468.94
38	$645,468.94	$3,227.34	$3,101.58	$642,367.36
39	$642,367.36	$3,211.84	$3,117.09	$639,250.27
40	$639,250.27	$3,196.25	$3,132.67	$636,117.59
41	$636,117.59	$3,180.59	$3,148.34	$632,969.25
42	$632,969.25	$3,164.85	$3,164.08	$629,805.17
43	$629,805.17	$3,149.03	$3,179.90	$626,625.27
44	$626,625.27	$3,133.13	$3,195.80	$623,429.47
45	$623,429.47	$3,117.15	$3,211.78	$620,217.69
46	$620,217.69	$3,101.09	$3,227.84	$616,989.86
47	$616,989.86	$3,084.95	$3,243.98	$613,745.88
48	$613,745.88	$3,068.73	$3,260.20	$610,485.68
Year #4 End
49	$610,485.68	$3,052.43	$3,276.50	$607,209.18
50	$607,209.18	$3,036.05	$3,292.88	$603,916.30
51	$603,916.30	$3,019.58	$3,309.34	$600,606.96
52	$600,606.96	$3,003.03	$3,325.89	$597,281.07
53	$597,281.07	$2,986.41	$3,342.52	$593,938.55
54	$593,938.55	$2,969.69	$3,359.23	$590,579.31
55	$590,579.31	$2,952.90	$3,376.03	$587,203.28
56	$587,203.28	$2,936.02	$3,392.91	$583,810.37
57	$583,810.37	$2,919.05	$3,409.87	$580,400.50
58	$580,400.50	$2,902.00	$3,426.92	$576,973.58
59	$576,973.58	$2,884.87	$3,444.06	$573,529.52
60	$573,529.52	$2,867.65	$3,461.28	$570,068.24
Year #5 End

Due to length issue only this much data can be provided.