please show how to enter into excel

360 periods

4. Amortized Home Loan You are planning to buy your dream house, which will cost you $250,000. You plan to get a 30 year conforming loan with an annual rate of 4.8% and a 20% down payment. Set up an amortization schedule (use Excel) for the mortgage to be repaid in equal installments at the end of each month for the next 30 years. (Use the amortization spreadsheet Advanced TVM: House Amortization") Periodi per yer Interest rates) Cost of Houte Downpayment Londo period years Compouning 30 monthly Nanber of periods Interest per period Monthly Payment Total Interest Total Payment BAN Monument Morthens Rosament of Final Tored Romance Pano 1 2 3 4