Please help
Part 2 A: (must be completed in Excel) Analysis: Using the budget in part 1; Use as many time lines as you need forecast all your projected savings(investments) to get each investments future value. You will have to determine your PV, 1/y, N, PMT then calc FV If you don't have any idea on the l/y you could use 5 or 6% to be conservative. N depends on your current age and when you think you will retire. Savings 401k or (403B) whichever you use IRA's.... Home Ect....... Once you add up all the future values from step 2 above, and do a time line to determine how much you will be able to spend each year assuming you are going to spend all your money. I.e. your future value will be 0. To calculate N, you have to make a lot of assumptions. For example, if you are planning on retiring at age 65 and think (hope) you will life until you are 90 (25 years) your N will be 25. 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 A: (must be completed in Excel) Analysis: Using the budget in part 1; Use as many time lines as you need forecast all your projected savings(investments) to get each investments future value. You will have to determine your PV, 1/y, N, PMT then calc FV If you don't have any idea on the l/y you could use 5 or 6% to be conservative. N depends on your current age and when you think you will retire. Savings 401k or (403B) whichever you use IRA's.... Home Ect....... Once you add up all the future values from step 2 above, and do a time line to determine how much you will be able to spend each year assuming you are going to spend all your money. I.e. your future value will be 0. To calculate N, you have to make a lot of assumptions. For example, if you are planning on retiring at age 65 and think (hope) you will life until you are 90 (25 years) your N will be 25. 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
