B c D Loan 2 200,000.00 30 2.56% LOAN ANALYSIS 2 3 4 come Monthly Income Loan Conditions Loan 1 5 Natasha $ 3,500 Loan Amount $ 450,000.00 $ 6 Bruce $ 3,500 Length of Loan (years) 15 7 Total $ 7,000 Annual Interest Rate 3,65% 8 Expenses Loan 1 Loan 2 Monthly Payment 10 Rent 1,200 $ 1,200 11 Food 850 850 12 Utilties 300 300 13 Phone 80 80 14 Loan Payments 250 250 15 Car Payments 225 225 16 Insurance 100 100 19 Miscellaneous 300 300 in Entertainment 200 200 19 Total 20 21 Net Income 2,000.00 15 22 23 24 25 Complete all the gray boxes. In cells B10:C10, use a cell reference to the calculated monthly mortgage payment to include 26 n the total expenses calculation 27 Can Natasha and Bruce afford the monthly payments required to purchase a house if they were to take a loan from a bank? 2 so please list which financing 29 30 32