b E LOAN ANALYSIS Income Natasha Bruce Total Monthly Income $ 3,500 $ 3,500 Loan Conditions Loan Amount Length of Loan (years) Annual Interest Rate Loan 1 Loan 2 $ 450,000.00 $ 200,000.00 15 30 3,65% 2.56% Monthly Payment 916075 $3250 22 15426.52 $796.49 80 Expenses Rant Food Uudes Phone Loan Payments Car Payments Insurance Miscellaneous Entertainment Total Loan 1 Loan 2 1.200 IS 1200 850 850 300 300 80 250 250 225 225 100 100 300 300 200 200 Net Income Complete all the gray boxes. In cells B10 C10, use a cell reference to the calculated monthly mortgage payment to include in the total expenses calculation Can Natasha and Bruce afford the monthly payments required to purchase a house if they were to take a loan from a bank? If so, please list which financing Den b E LOAN ANALYSIS Income Natasha Bruce Total Monthly Income $ 3,500 $ 3,500 Loan Conditions Loan Amount Length of Loan (years) Annual Interest Rate Loan 1 Loan 2 $ 450,000.00 $ 200,000.00 15 30 3,65% 2.56% Monthly Payment 916075 $3250 22 15426.52 $796.49 80 Expenses Rant Food Uudes Phone Loan Payments Car Payments Insurance Miscellaneous Entertainment Total Loan 1 Loan 2 1.200 IS 1200 850 850 300 300 80 250 250 225 225 100 100 300 300 200 200 Net Income Complete all the gray boxes. In cells B10 C10, use a cell reference to the calculated monthly mortgage payment to include in the total expenses calculation Can Natasha and Bruce afford the monthly payments required to purchase a house if they were to take a loan from a bank? If so, please list which financing Den