Create a financial business plan for a hypothetical business venture. You will need to consider all possible costs and revenues for your business and use the functions covered in class to conduct financial analysis of the business.

2. Begin with a single Excel or Google Sheets workbook. On the first tab (worksheet) create a monthly budget estimate with expected monthly expenses and revenues for the first year of business operations. Use as much detail as possible. Use proper formatting for numbers and dates. Format headings and separate revenues from expenses using a formatting technique that makes the monthly budget easy to read. Use equations as much as possible.

3. On a second tab (worksheet) in the workbook, create an annual budget showing periods of expected increases in revenue and periods of increases in costs. Monthly costs can be aggregated in the categories of fixed expenses and variable expenses. Proper formatting should be used in order to make the spreadsheet easy to read and understand. Use equations as much as possible. All 12 months should be represented on this spreadsheet.

4. On a third tab (worksheet) in the workbook, create a five-year budget showing expected increases or decreases in costs and revenues. Annual costs can be aggregated so that all monthly estimates are combined into an annual value. Formatting and equations should be the same as previous worksheets in the workbook.

5. Based on your 5-year estimates, calculate the Net Present Value of your business plan, the Internal Rate of Return on your initial investment, and the Payback Period for your investment. Additionally, use the goal-seek function to determine at least one factor in your business plan (i.e. what do monthly revenues need to be in order to have a X% IRR?)