Please show formulas in excel.

Monthly Rent $ 3,000.00 Outstanding Loan Balance in Year 2 5 10 276 240 Purchase Price $ 600,000.00 e) 180 # of months remaining Outstanding Loan Balance Down Payment (20%) Legal fees f) If Buy $ $ $ $ Deed transfer tax (@3%) Total Due at Closing 120,000.00 2,000.00 18,000.00 140,000.00 price change Selling price realtor fee (5%) other selling fees Net Proceeds @ sales year (=selling price-loan balance-fees) 0% 600,000 30,000 2,000 $ 0% 600,000 30,000 2,000 $ 0% 600,000 30,000 2,000 $ . Monthly Condo Fees Monthly Taxes Monthly Repairs etc. $ $ $ 1,055.00 300.00 50.00 If Rent Closing Cost savings @ sales year Mo. Payment Diff savings @ sales year (Use ((b)- monthly rent) as PMT) Total Savings if Rent @ sales year Loan Payoff Period (Years) Payment Frequency Quoted Annual Rate * Please fill out the yellow blank cells. Present positive numbers for your answers. 25 12 4% Net Gain @ sales year PV of Net Gain $ w/ instructor in class a) Loan Amount # of months monthly rate (=1/12* quoted rate, mo. compounding) Mortgage Payment 480,000.00 300 0.33% $2,533.62 If Buy b) Total Monthly Out-of-pocket Payments If Buy price change (simple annual compounding) Selling price realtor fee (5%) other selling fees Net Proceeds @ sales year (=selling price-loan balance) c) Monthly Opportunity Costs If Buy (=interest income lost) Total Monthly Payments If Buy (incl. Opp. Costs) If Rent d) Diff between Buy and Rent (incl. Opp. Costs) Closing Cost savings @ sales year Mo. Payment Diff savings @ sales year Total Savings if Rent @ sales year Net Gain @ sales year PV of Net Gain Monthly Rent $ 3,000.00 Outstanding Loan Balance in Year 2 5 10 276 240 Purchase Price $ 600,000.00 e) 180 # of months remaining Outstanding Loan Balance Down Payment (20%) Legal fees f) If Buy $ $ $ $ Deed transfer tax (@3%) Total Due at Closing 120,000.00 2,000.00 18,000.00 140,000.00 price change Selling price realtor fee (5%) other selling fees Net Proceeds @ sales year (=selling price-loan balance-fees) 0% 600,000 30,000 2,000 $ 0% 600,000 30,000 2,000 $ 0% 600,000 30,000 2,000 $ . Monthly Condo Fees Monthly Taxes Monthly Repairs etc. $ $ $ 1,055.00 300.00 50.00 If Rent Closing Cost savings @ sales year Mo. Payment Diff savings @ sales year (Use ((b)- monthly rent) as PMT) Total Savings if Rent @ sales year Loan Payoff Period (Years) Payment Frequency Quoted Annual Rate * Please fill out the yellow blank cells. Present positive numbers for your answers. 25 12 4% Net Gain @ sales year PV of Net Gain $ w/ instructor in class a) Loan Amount # of months monthly rate (=1/12* quoted rate, mo. compounding) Mortgage Payment 480,000.00 300 0.33% $2,533.62 If Buy b) Total Monthly Out-of-pocket Payments If Buy price change (simple annual compounding) Selling price realtor fee (5%) other selling fees Net Proceeds @ sales year (=selling price-loan balance) c) Monthly Opportunity Costs If Buy (=interest income lost) Total Monthly Payments If Buy (incl. Opp. Costs) If Rent d) Diff between Buy and Rent (incl. Opp. Costs) Closing Cost savings @ sales year Mo. Payment Diff savings @ sales year Total Savings if Rent @ sales year Net Gain @ sales year PV of Net Gain