For more course tutorials visit www. uophelp. com
For more course tutorials visit www. uophelp. com
Scenario / Summary You are an intern at First National Bank working in the loan department, and your boss has asked you to prepare the monthly " New Loan Report " for the Board of Directors. This analysis report will clearly list and summarize all new loans for residential housing in the past month. The summary area includes the loan statistics as labeled data in the data file. The format of the report should be appropriate for the Board of Directors for the First National Bank. Be sure to watch the tutorials at the end of the Lesson page. Deliverables Step 1: Open, Save, and Document the Workbook A. Download the Week2 _ iLab _ FirstNatlBank _ Students. xlsx Workbook. Open the file in Excel, and save it as the file name as describe above( i. e., Doe _ J _ Week2 iLab. xlxsm). [ Note: You may get a popup message that asks you to " Enable Saving ". Simply click " Yes " to Enable and you will be able to save the file ] B. It is recommended that as you progress through this assignment, that you work on what you have learned so far, in terms of readability. Be sure to keep your worksheet professional with easy to read column headings, shading, spacing, boxes, logos, and so on. Remember to label your worksheets with appropriate labels( i. e., not sheet1, sheet2, etc.). C. Add a documentation sheet that provides a spreadsheet title, author, date, and purpose. Format the documentation sheet. The bank ' s logo is dark blue, so use a color scheme that reflects that logo. Select complementary Font and Fill colors for the documentation sheet. Ensure that the sheet tab is named Documentation and that the documentation sheet is the first sheet in the workbook. Step 2: Create Calculations Functions are used to calculate the interest rate, down payment, monthly payment, and average selling price for each residential home in the worksheet. You need to create a formula to determine the down