excel formula.

please write out the formula for #3

1. B D 4.45 184 Loan Payment Calculator 9/15/21 Rate Charles Street Term in Months $ $ $ 920,000 Total Cost fx Liam Richardson is the business manager for the Smith & Lyngate Insurance agencies in the state of Maryland. Llam is interested in increasing the number of agents in Baltimore and plans to buy an office building for the new operation. He has asked for your help in uilding creating a loan analysis that summarizes information about the loans to cover the cost of the building. Go to the Loan Calculator worksheet. The cells in the range B6:38 have defined names, but one is incomplete and could be confusing. Cell A2 also has a defined name, which is 1,150,000 Monthly Payment unnecessary for a cell that will not be used in a formula. 230,000 Total Interest Update the defined names in the worksheet as follows: Varying Interest Rates and Terms a. Delete the Loan_Calculator defined name. Number of Months For cell B8, edit the defined name to use Loan_Amount as the name. In cell B8, calculate the loan amount by entering a formula without using a function that subtracts the Down_Payment from the Price Llam also wants to use defined names in other calculations to help him interpret the formula In the range D4:08, create defined names based on the values in the range C4:08. 120 180 240 b. 2. 3