Please show the steps

BoyuQuCh7CaseStudy - Excel File Insert Page Layout Formulas Data Review View Add-ins ACROBAT QuickBooks Tell me what you want to do Sign in Share Autosum Calibri Fill Paste u . re. O . . _ _ Merge & Center. $. % , 'i..g Conditional Format as Cell Insert Delete Format Sort & Find & Filter Select Formatting Table Styles Clipboard Font Alignment Number Cells Editing E3 Input Area Calculations 2 Facility Costs $ 720,000.00 3 Down Payment $250,000.00 12 Loan Amount No. Periods Monthly Rate Monthly Payment Total Interest Paid 470,000.00 4 # of Pmts per Year 5 Years 6 APR 5.25% Beginning Balance Ending Balance Interest Principal 10 nt # 12 13 14 15 16 17 18 19 21 23 25 28 29 30 31 32 34 cquisition Ready 100% 3:14 PM Type here to search ^ 4) ENG 2019-01-23 222222 pdf-Adobe Acrobat Pro DC File Edit View Window Help Home Tools Document Q 1/2 For the purpose of grading the project you are required to perform the following tasks: Points Step Instructions Open Ch7CaseStudy.xlsx file and save as LastNameFirstNameCh7CaseStudy.xlsx. In cell E3, enter a formula to calculate the Number of Periods referencing the applicable cells in the Input Area. In cell E4, enter a formula to calculate the monthly interest rate referencing the applicable 3 cells in the Input Area. Format the result as Percent and 2 decimal places. In cell E5, use a function to calculate the monthly payment referencing the applicable cells in the Summary Calculations area. Show the result as a positive number In the Payment # column, enter in values for 5 payments. Note: Be sure to complete the column only through row 15. In cell B11 enter the correct reference to the beginning balance In the Interest Paid and Principal Payment columns, use financial functions to calculate the Interest Paid and Principal Payment for the first payment. Show all results as positive 10 In cell E11, enter a formula that will calculate the Ending Balance for the first payment. 8 In cell B12 enter the correct cell reference that retrieves the Ending Balance (after payment Complete the rest of the table by copying down the formulas. (Hint: be careful when copying the formula down the Beginning Balance column that you choose the correct cell to copy 10 down. Depending on the column you copy down first, you may see zeros as results until the other columns are copied.) 3:15 PM Type here to search ^ 4) ENG 2019-01-23 222222 pdf-Adobe Acrobat Pro DC File Edit View Window Help Home Tools Document Q 2 /2 Points Step Instructions In cell E6, enter a function that will calculate the cumulative interest paid after five payments. for the start and end period arguments. Leave the result as a negative number Format all monetary values in the table and the summary calculations area as Accounting 11 Reference the loan information in E2:E4 and the corresponding Payment number in the table 12 format to 2 decimal places. Save and close the file. Upload the closed file to the XLCh7 Case Study link in Myitlab. 13 0 Total Points 32 3:15 PM Type here to search ^ 4) ENG 2019-01-23