11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Home H12 A Excel File Edit View Insert Insert B AutoSave OFF Cash Inflows Cash Outflows x Other Other Draw Page Layout D For month ending Salary (take-home) Other income: Other income: Total Income fx Set Up Your Variance Feb - Jan Fixed Expenses Mortgage or rent Loan payments Insurance Total fixed outflows Variable Expenses Food Clothing Electricity Telephone Water I Transportation Personal care Medical expenses Recreation/entertainment Gifts Donations Other Other Total variable outflows Total Outflows Surplus/Deficit E F Data Jan-23 72 use the rows below for your calculation 73 $0.00 $0.00 $0.00 $0.00 $0.00 63 64 Use the data below for your calculations: 65 * 10 percent down payment 66 33 percent for TIPI 67 *450 for credit card debt 68 *375 for personal laon 69 * 6 perscent interest ratye on a 30 year mortgage 70 71 G Data Formulas Feb-23 $0.00 $0.00 $0.00 Format Tools Data Window Help $0.00 $0.00 H Set Up Your Variance Feb - Jan $0.00 $0.00 $0.00 $0.00 Your Financial Workbook - HW Assignment 3 - Bud Review Tell me Data Data Mar-23 $0.00 $0.00 $0.00 $0.00 $0.00 J Set Up Your Variance Feb -- March $0.00 $0.00 $0.00 $0.00 $0.00 K View L Set Up Your Budget Monthly Budget 52 53 54 55 56 What's Next for Your Personal Financial Plan? 58 1) Calculate your variances (February and january) 59 2) Calculate your variances from (march to February) 60 3. Calculte your monthly budget based on 3 months of data collected. 61 4) You are estimating you will be putting$ 10 percent to cover down payment from your saving account 62 Calculate your affordable mortgage amount h-that would be suggested by a lending institution based on your estimated income of 56,000 per year. M Automate N O P R