For this project, you are to prepare an “Educational Cost Plan Summary” in Excel (workbook consisting of fiveworksheets). In the process of doing the projectworkbook, you will make decisions aboutwhat schools you plan to attend, whether you will live on campus, at-home, or off-campus not at home, what expenses you will incur, how many full-time and part-time hours you will work while in college, and what type of educational loan you may wantor need. Much of the information you will need to complete the project can be found on the Web, but some of it you will need to provide on a trialbasis. When you have completed the project, you will have a hypothetical set of college expenses, employment income, educational resources, and loan repayment informationthat can be used to get you thinking about how you plan to pay for your college education. The workbook will consist of five worksheets entitled: Educational Cost Plan Summary, College Expense Plan, Employment Income Plan, Educational Resource Plan, and Loan Repayment Plan. Each worksheet will be used to calculate and display information relevant to the title of that worksheet. Information calculated on one worksheet should not be re-calculated on another worksheet. Instead, information should be shared across the workbook by using cell references that reference cells across worksheets. All tables and figures on worksheets will be formatted as shown in the appendix of this document, which contains an “Example Educational Cost Plan Summary” (points will be deducted if you do not follow the formatting provided – You can select a different format for tables, but you must use the format consistently through the workbook). Numbers shown on all worksheets should be the result of calculations preformed within the workbook and implement formulas and functions (including relative and absolute cell referencing where appropriate) to the greatest extent possible. In other words, you may not perform calculations outside the workbook and then enter the results of these calculations into a worksheet. All calculations must be performed on the appropriate worksheets. The “Example Educational Cost Plan Summary” contained in the appendix of this document is provided as a guideline for the layout and formatting of your project. Please follow it very carefully, as you will lose points if you do not format numbers, labels, tables, and figures appropriately. The numbers contained in the Example Educational Cost Plan Summary may not to be simply duplicated into your project. These numbers are for example purposes only.