- In column D write a function that automatically calculates the down payment required based on the credit score in column C. If the credit score is below 450 then the customer must pay the high risk cut off amount percentage. If not they pay the low risk percentage. (You should use a function.)

AutoSave 2 John MS100 Assignments PMTFV_Start Excel Scarch Lesauski, Justin File Home Insert Page Layout Formulas Data Review View Help Finess Data Share Comments . AutoSum Verdana 10 ~A A == 82 Wrap Text General M 27 X Out [Copy Paste * Format Painter Cipboard Insert Delete format Sensitivity BIU Merge Center Clear Conditional format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Eding Analyze Data Font Alignment Number Cels Analysis Sersity K42 A B D H 1 Bulldog Mortgages 1 2 House Cos 982.00 Amount Financed Mortgage Rate 4 Down payment rate Mortgage APR 5 High risk down payment 15.00% Low risk down payment % 6 5.00% 3.504 7 Low risk cut off 450 R 9 Loan Credit Score Down Payment % Financed 10 740576 S 3R2 11 2751995 297,231.00 186 12 360425 359,085.00 543 12 269541 S 427,257.00 13/ 14 387508 $ 241.260.00 467 15 7384391 S 387,484.00 484 16 229761 $ 114,343.00 261 17 274363 287 208.00 515 19 345927 464.6111.00 235 19 323245 $ 257,570.00 569 333036 S 496,877.00 158 21 327395 S 349.955.00 605 22 348067 S 233,728.00 128 2091391 $ 228,983.00 652 24 236766 $ 209.085.00 571 75 301857 s 384,693.00 361 26 376626 $ 263,326.00 112 27 284862 352,905.00 475 214631 S 137,534.00 229 29 343404 5 103,195.00 670 30 31 32 You are wordng as a mortgage broker and have been given the task of creating a sprcadsheet to determine basic loan information for this months financed mortgages. Use the table below to complete the following tasks. 34 35 - In column write a function that automatically calculates the down payment required based on the credit score in