Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF MAP ? C ... Your Financial Workbook - HW Assignment 3 - Bud Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me H12 X V fx Set Up Your Variance Feb - Jan C D M N O P Q R Set Up Your Set Up Your Variance Feb - Variance Feb - Set Up Your Data March Jan-23 Data Jan Mar- 23 Budget Monthly For month ending Feb-23 Budget Cash Inflows Salary (take-home) Other income Other income : Total Income sood so.od Cash Outflows Fixed Expenses Mortgage or ren Loan payments Insurance Other, Other Total fixed outflows sped so.od Variable Expenses Food Clothing Electricity Telephone Water Transportation Personal care Medical expenses Recreation/entertainment Gifts Donations Other Other Total variable outflows $0.00 $0.00 $0.00 $0.00 Total Outflows $0.00 $0.00 $0.00 $0.00 $0.00 Surplus/Deficit $0.00 $0.00 $0.00 $0.00 $0.00 What's Next for Your Personal Financial Plan? 1) Calculate your variances (February and january) 2) Calculate your variances from (march to February) 3. Calculte your monthly budget based on 3 months of data collected. 4) You are estimating you will be putting$ 10 percent to cover down payment from your saving account Calculate your affordable mortgage amount h=that would be suggested by a lending institution based on your estimated income of 56,000 per year. Use the data below for your calculations * 10 percent down payment * 33 percent for TIPI * 450 for credit card debt * 375 for personal laon 6 perscent interest rate on a 30 year mortgage 72 use the rows below for your calculation 73