WK1 Excel is Fun Workbook.xlsm Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW OFFICE TAB ACROBAT Split _ Hide Unhide IDDView Side by Side | LEI Synchronous Scrolling Normal Page Break Page Custom Gridlines Headings Zoom 100% Zoom to New Arrange Freeze SwitchMacros Reset Window Position Windows Preview Layout Views Workbook Views Selection Window All Panes Show Zoom Window Macros F11 WK1 Excel is Fun Workbook.xlsm* $25,000.00 Annual Interest Rate $5,000.00 Monthly Interest Rate 2 Price of Car 3 Down Payment 4 Loan Amount 5 Monthly Payment 6 7 Instructions: 8 1) Create the Calculating Formulas in green cells 9 2) Format cell B5 to show Currency without parenthesis for negative numbers 10 3) Fix the Alignment in the range A1:D1 11 4) Create a Text Formula in cell A1 that says "Your Payment Each Period Is $XXX.XX". 12 5.95% 3 Years for Loan Total Months