Calculate the APR and create an Amortization Table

E F G H I L M N 1 Objective: estimate monthly cash flow 2 3 Input area Given information 4 5 $200,000 year APR 6 $1,000.00 30 0.0350 7 Price of the house downpayment loan amount number of years transaction cost $300,000.00 15 0.0300 0.0250 8 30 10 9 $1,770.00 10 11 12 output area 13 14 monthly cash flow True monthly rate APR $830.56 = (E7-E6)/(E8*12) 0.28% =RATE(360, E14,- (E7-E9), E7) 15 16 B D E F G 1 Objective: contruct an amortization table 2 Given information 3 3 4 loan amount year mortgage rate monthly payment 200000 15 0.28% APR year 30 5 0.035 6 15 0.03 7 10 0.025 00 8 9 Beginning balance monthly payme interest payr principal red end of period balance 200000 $0.00 10 E F G H I L M N 1 Objective: estimate monthly cash flow 2 3 Input area Given information 4 5 $200,000 year APR 6 $1,000.00 30 0.0350 7 Price of the house downpayment loan amount number of years transaction cost $300,000.00 15 0.0300 0.0250 8 30 10 9 $1,770.00 10 11 12 output area 13 14 monthly cash flow True monthly rate APR $830.56 = (E7-E6)/(E8*12) 0.28% =RATE(360, E14,- (E7-E9), E7) 15 16 B D E F G 1 Objective: contruct an amortization table 2 Given information 3 3 4 loan amount year mortgage rate monthly payment 200000 15 0.28% APR year 30 5 0.035 6 15 0.03 7 10 0.025 00 8 9 Beginning balance monthly payme interest payr principal red end of period balance 200000 $0.00 10