Instructions:

Your report is based on the data that you have been collecting so far since the beginning of the class. Please Use the attached Excel sheet if needed

https://docs.google.com/spreadsheets/d/1qYmhUHwdFP3UUONA6cqemEgJBqnIOleLjJzMKHz JZsk/edit#gid=247634732

Your analysis should be based on the data you have been tracking since the first day of this class. You should have at least one month's data that shows your expenses and all incomes. Make sure you detailed all sources of income and catagorised all your expenses into fixed, variable, and discretionary costs. Use this on or 2-month budget and expand it to 12 months which shows your annual budget.

Based on your annual budget,

Prepare cash flow statement. Just like your previous individual assignment, add screenshots of your financial analysis (from Excel). Use a pie chart that shows your categorized expenses.

Comment on your spending habit and pinpoint options to reduce your expenses.

Create budget and link that to your SMART goal (Retirement).

Even if you are not investing currently, write about your investment plans in the future. Discuss the types of funds that help you achieve your goal. Choose a specific asset allocation that matches your risk tolerance by creating a pie chart in Excel of specific investments that you could invest in. Please choose any investment that you think is better from the link below.

https://www.nerdwallet.com/article/investing/the-best-investments-right-now

Prepare your balance Sheet that contains your Net Worth at some point in the future.

Explain your risk management plans. Throughout your report, include many text notes to help you explain your thinking.

Income Amount Annually Fairmont Hotel $ 6,622.58 $ 46,358.06 Covention Centre $ 374.15 $ 2,619.05 Total Income $ 6,996.73 $ 48,977.11 Taxes Fairmont Hotel Federal Tax Deduction 6,284.00 Provincial Tax Deduction $ 2,272.00 CPP Deduction 2,443.00 El Deduction 732.00 Total Deduction $ 11,731.00 Convention Centre Federal Tax Deduction 194.00 Provincial Tax Deduction $ CPP Deduction El Deduction 41.38 Total Deduction 235.38 Net Pay Fairmont Hotel $ 34,627.06 Convention Centre $ 2,383.67EXPENSES Annually Notes Sub-Heading Housing April 1,500.00 Fixed Cost May S 1,500.00 Fixed Cost Subtotal: S 3,000.00 Subtotal: $ 18,000.00 Transportation April 205.10 Fixed Cost un un May 205.10 Fixed Cost Subtotal: 410.20 Subtotal: $ 2,461.20 Fixed Cost Food & Clothing April S 1,674.53 Variable Cost May 3,979.90 Variable Cost Subtotal: S 5,654.43 Subtotal: $ 67,853.16 Medical April 75.00 Fixed Cost May 75.00 Fixed Cost Subtotal: 150.00 Subtotal: S 900.00 Miscellaneous April 20.44 Variable Cost May S 3,564.60 Variable Cost Subtotal: S 3,585.04 Subtotal: $ 43,020.48 Education April $ 5,000.00 Varibale Cost May S Subtotal: S 5,000.00 Subtotal: $ 5,000.00 Savings April ur 1,083.33 May S 1,083.33 Subtotal: S 2,166.66 Subtotal: $ 12,999.96 Other Expenses April $ 1,608.25 Discretionary Cost May S 228.32 Discretionary Cost Subtotal: 1,836.57 Subtotal: $ 22,038.84 Total Expenses $ 21,802.90