Question

1 Approved Answer

Posted on Jul 29, 2024

Please help Part 2 B: (must be completed in Excel) Scenario Analysis: Run at least 3 different scenarios to see the impact of decisions. Some

Please help image text in transcribed

Part 2 B: (must be completed in Excel) Scenario Analysis: Run at least 3 different scenarios to see the impact of decisions. Some examples may include: What happens if you delay start of Savings for 5 years? What happens if you work 3 more years? What if the interest rate is higher/lower? What if you have more to save after student loans are paid off? A B D G H K 1 M N 1 OUTGOINGS JAN FEB MARCH APRIL MAY JUNE JULY AUG SEPT OCT NOV DEC ells Rent $1,350.00 $1,150.00 $1,350.00 $1,150.00 $1,150.00 $1,150.00 $1,350.00 $1,350.00 $1,350.00 $1,150.00 $1,150.00 $1,350.00 Utility - Gas $141.73 $ 275.53 $ 148.17 S 112.66S 94.55 $59.54 $ 26.35 $ 25.54 $ 2238 S 30545 87.87 S 13178 Utility-lectricity $ 109.96 $ 92.24 S 101.94 S 9.62 S 20.25 $ 67,95 78.59 $ 124.20 $ 95 41 S 62.07 S 57.27S 61.9 5 Utility - Water $ 13 $ 323.23 $32323 S32323 6 Child Care $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 S 600.00 $ 600.00 Cell Phone $ 175 S 125.82 $ 125.82 $125.82 $ 125.82 $ 125.82 $ 125.82 $ 125.82 $125 S 125.82 $ 125.82 $ 125.82 8 Car Car Insurance $ 12152 S121525 123.52 S 114 115 114 115 114.11 S 114 11 S 12.525 123525 12152 S123.52 S12152 9 Car Maintenance S 602.78$ $ 33.50 $ 535.225 $ 33.50 3350 5 33.50 $ $ S 10 Gas Vehicle $ 400.00 $ 400.00 $ 210.00 S 90.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 200.00 $ 300.00 $ 400.00 $ 400,00 11 Entertainment Net $ 25.00 $ 25.00 $ 25.00 5 25.00 S 25.00 $ 25.00 5 25.00 $ 25.00 5 25.00 $ 25.00 $ 25.00 $ 25.00 12 Internet/W $ 60.00 $ 60.00 $0.00 $ 60.00 S 60.00 $ 60.00 $ 60.00 $ 60.00 $ 60.00 $ 60.00 $ 60.00 $ 60.00 13 Food & Drinks Groceries $ 436.02 $ 663.87 $ 505.32 S 697.15 S 837.10 $1,005.07 $ 99.39 $ 956.22 $ 711.62 $ $23.45 S 551.11 S 489.63 14 Dining Out S 89.36 S 5 S $ 52.92 $ 13562 S 128.75 $ 220 12 S 156.89S 65.21 $ 15 Miscellaneous ATM $ 120.00 $ $ $ $ 250.00 $ 100.00 $ 250.00 $ 300.00 $ 150.00 $ 250.00 $ 100.00 $ 100.00 16 TOTAL EXPENSES S4,1M.19 S1,715.98 $3,646.50 $3,284.56 $4,162.05 $4,017.11 $3,854** $ 1,919.05 $4,040.60 $3,607.29 $3,745.80 $4,122.12 17 18 INCOME Gross Salary $4,333.00 $4,331.00 $4,33300 54,333,00 4,131.00 $4,111.00 $4,393.00 $4,333.00 $4,333.00 $4,331.00 $4,311.00 $4,133.00 19 Net Salary S24.00 $3,234.00 $3,234.00 $3,2,00 SM.00 S234.00 $3,234.00 $3,224.00 $3,234.00 $3,234.00 $3,234.00 $3,234.00 20 Child Support $1,500.00 $1,500.00 $1,500.00 $ 1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 21 TOTAL INCOME S47M.00 S47.00 $4,74.00'54.71.00 PS4,744.00'S4,724.00 $4,74.00 $4,71.00 PS4,700 47.00 $4,74.00 PS4,724.00 22 23 NET/TOTAL SAVINGS NET $549 81 51,018.02 $1,03/051409.44 5571.955 716 S 8/9125814.95 S 9340 51,176/1520S 6118 0 P Q BUDGET ACTUAL $ 16,200.00 $ 16,200.00 $ 1,300.00 $ 1,176.64 $ 1,200.00 5 1,011,46 $ 1,300.00 $ 1.292.92 $ 7,200.00 $ 7,200.00 $ 1,560.00 $ 1,500 $ 1.500.00 S 1444,60 $ 1,000.00 $ 1.272.00 $ 4,800.00 S 2,840.00 5 300.00 5 10000 $ 220.005 720.00 $10,000.00 $ 166 15 $ 1,200.00 5 94652 $7,000.00 $ 7,030.00 $50,280.00 $ 46,00.13 $ 51,996.00 $ 38,0.00 $ 18,000.00 $ 56,000 $ 10,507. Part 2 B: (must be completed in Excel) Scenario Analysis: Run at least 3 different scenarios to see the impact of decisions. Some examples may include: What happens if you delay start of Savings for 5 years? What happens if you work 3 more years? What if the interest rate is higher/lower? What if you have more to save after student loans are paid off? A B D G H K 1 M N 1 OUTGOINGS JAN FEB MARCH APRIL MAY JUNE JULY AUG SEPT OCT NOV DEC ells Rent $1,350.00 $1,150.00 $1,350.00 $1,150.00 $1,150.00 $1,150.00 $1,350.00 $1,350.00 $1,350.00 $1,150.00 $1,150.00 $1,350.00 Utility - Gas $141.73 $ 275.53 $ 148.17 S 112.66S 94.55 $59.54 $ 26.35 $ 25.54 $ 2238 S 30545 87.87 S 13178 Utility-lectricity $ 109.96 $ 92.24 S 101.94 S 9.62 S 20.25 $ 67,95 78.59 $ 124.20 $ 95 41 S 62.07 S 57.27S 61.9 5 Utility - Water $ 13 $ 323.23 $32323 S32323 6 Child Care $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 S 600.00 $ 600.00 Cell Phone $ 175 S 125.82 $ 125.82 $125.82 $ 125.82 $ 125.82 $ 125.82 $ 125.82 $125 S 125.82 $ 125.82 $ 125.82 8 Car Car Insurance $ 12152 S121525 123.52 S 114 115 114 115 114.11 S 114 11 S 12.525 123525 12152 S123.52 S12152 9 Car Maintenance S 602.78$ $ 33.50 $ 535.225 $ 33.50 3350 5 33.50 $ $ S 10 Gas Vehicle $ 400.00 $ 400.00 $ 210.00 S 90.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 200.00 $ 300.00 $ 400.00 $ 400,00 11 Entertainment Net $ 25.00 $ 25.00 $ 25.00 5 25.00 S 25.00 $ 25.00 5 25.00 $ 25.00 5 25.00 $ 25.00 $ 25.00 $ 25.00 12 Internet/W $ 60.00 $ 60.00 $0.00 $ 60.00 S 60.00 $ 60.00 $ 60.00 $ 60.00 $ 60.00 $ 60.00 $ 60.00 $ 60.00 13 Food & Drinks Groceries $ 436.02 $ 663.87 $ 505.32 S 697.15 S 837.10 $1,005.07 $ 99.39 $ 956.22 $ 711.62 $ $23.45 S 551.11 S 489.63 14 Dining Out S 89.36 S 5 S $ 52.92 $ 13562 S 128.75 $ 220 12 S 156.89S 65.21 $ 15 Miscellaneous ATM $ 120.00 $ $ $ $ 250.00 $ 100.00 $ 250.00 $ 300.00 $ 150.00 $ 250.00 $ 100.00 $ 100.00 16 TOTAL EXPENSES S4,1M.19 S1,715.98 $3,646.50 $3,284.56 $4,162.05 $4,017.11 $3,854** $ 1,919.05 $4,040.60 $3,607.29 $3,745.80 $4,122.12 17 18 INCOME Gross Salary $4,333.00 $4,331.00 $4,33300 54,333,00 4,131.00 $4,111.00 $4,393.00 $4,333.00 $4,333.00 $4,331.00 $4,311.00 $4,133.00 19 Net Salary S24.00 $3,234.00 $3,234.00 $3,2,00 SM.00 S234.00 $3,234.00 $3,224.00 $3,234.00 $3,234.00 $3,234.00 $3,234.00 20 Child Support $1,500.00 $1,500.00 $1,500.00 $ 1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 21 TOTAL INCOME S47M.00 S47.00 $4,74.00'54.71.00 PS4,744.00'S4,724.00 $4,74.00 $4,71.00 PS4,700 47.00 $4,74.00 PS4,724.00 22 23 NET/TOTAL SAVINGS NET $549 81 51,018.02 $1,03/051409.44 5571.955 716 S 8/9125814.95 S 9340 51,176/1520S 6118 0 P Q BUDGET ACTUAL $ 16,200.00 $ 16,200.00 $ 1,300.00 $ 1,176.64 $ 1,200.00 5 1,011,46 $ 1,300.00 $ 1.292.92 $ 7,200.00 $ 7,200.00 $ 1,560.00 $ 1,500 $ 1.500.00 S 1444,60 $ 1,000.00 $ 1.272.00 $ 4,800.00 S 2,840.00 5 300.00 5 10000 $ 220.005 720.00 $10,000.00 $ 166 15 $ 1,200.00 5 94652 $7,000.00 $ 7,030.00 $50,280.00 $ 46,00.13 $ 51,996.00 $ 38,0.00 $ 18,000.00 $ 56,000 $ 10,507