80.2K

Verified Solution

Link Copied!

Pleaseeeee I really need help on this!!!! :)) thankz

Financial planning cases 7-1 The Johnsons' Credit Questions They are considering trading their car in for a newer used vehicle so that Harry can have dependable transportation for commuting to work. The couple still owes $5,310 to the credit union for their current car, or $295 per month for the remaining 18 months of the 48-month loan. The trade-in value of this car plus $1,000 that Harry earned from a freelance interior design job should allow the couple to pay off the auto loan and leave $1,100 for a down payment on the newer car. The Johnsons have agreed on a sales price for the newer car of $16,000. The money planned for tires will be spent for other incidental taxes and fees associated with the purchase a. Make recommendations to Harry and Belinda regarding where to seek financing and what APR to expect The input in the box below will not be graded, but may be reviewed and considered by your instructor blank b. Using the Garman/Forgue companion website or the information in Table 7-2, calculate the monthly payment for a loan period of three, four, five, and six years at 7 percent APR. Round your answers to the nearest cent Round Monthly installment Payment for a Loan in intermediate calculations to the nearest cent. For a 3-year loan: For a 4-year loan: $ For a 5-year loan: $ For a 6-year loan: $ Describe the relationship between the loan period and the payment amount The input in the box below will not be graded but may be reviewed and considered by your instructor The input in the box below will not be graded, but may be reviewed and considered by your instructor blank c. Harry and Belinda have a cash-flow deficit projected for several months this year (see Table 3-6 and Table 3-7). Suggest how, when, and where they might finance the shortages by borrowing, The input in the box below will not be graded, but may be reviewed and considered by your instructor blank Table 3-6 2018 Unfinished Annual Budget Estimates for Harry and Belinda Johnson Jan. Feb. Yearly Monthly Total Averages Mar Apr May June July Aug. Sept. Oct Nov Dec. INCOME Harry's salary Belinda's salary Interest Income from trust 4,080 6,400 4,080 4,080 4,080 6,400 6,400 6,400 30 30 30 0 0 0 10,510 10,510 10,510 4,080 6,400 30 0 10,510 4,080 6,400 30 0 10,510 4,00 6,400 30 0 10,510 4,00 6,400 30 0 10,510 4,080 6.400 30 3,000 13.510 4,080 6,400 30 4,080 6,400 30 4,080 6,400 30 0 10,510 48,960 76,800 360 3,000 129,120 4,080.00 6,400.00 30.00 250.00 10,760.00 10,510 10,510 10,510 1,700 1,600 300 1,600 300 19,800 3,900 20 240 0 2,500 220 300 EXPENSES Fixed Expenses Rent Health insurance Life insurance Home purchase fund Renter's insurance Automobile insurance Auto loan payments Student loan payments Savings/emergencies Harry retirement plan Belinda's retirement plan Cable TV and Internet Federal income taxes State income taxes Social security taxes Automobile registration Total fixed expenses Variable Expenses Savings money market Revolving savingsfund Food thome) Food Love 195 1,650.00 325.00 2000 208.33 18.33 100.00 490.00 300.00 100.00 195.00 400.00 160.00 1,700.00 500.00 800.00 25.00 6,991.67 500 0 600 490 300 100 195 400 160 1,700 500 800 0 7.815 400 400 100 400 400 160 160 1,200 5,880 3,600 1,200 2,340 4,800 1.920 20,400 6,000 9,600 300 83.900 400 160 1,700 160 160 1,700 500 1,700 160 1,700 400 160 1,700 500 BOD 1,700 500 300 700 700 160 1.700 500 300 SOO 400 160 1.700 500 BOD 300 7,515 500 300 800 0 6,715 6,565 6,565 0 7.215 5,565 6,565 6,565 7,165 7,215 3,000 0 250 550 300 0 250 550 0 0 0 210 550 300 250 550 300 0 190 550 300 0 0 550 300 400 240 550 300 550 300 550 300 190 550 300 550 300 550 300 3,400 70 5.600 3.600 148.33 550.00 300.00 550 550 550 550 550 300 550 300 220 300 300 300 550.00 300.00 220 110 220 110 5506,600 300 3,600 220 2,640 110 1,320 2,640 1,200 110 220 110.00 220.00 100.00 100 Food (home) Food (out) Utilities Cell phones Auto gas repairs Doctor/dentist out-of-pocket Medicines Clothing and upkeep Church and charity Gifts Public transportation Personal allowances Entertainment European vacation Summer vacation Anniversary dinner party Miscellaneous Total variable expenses 140 100 300 500 720 2,040 1.160 1,475 1,920 6,000 1,800 3,600 1,200 500 1.200 44,795 60.00 170.00 96.67 122.92 160.00 500.00 150.00 300.00 100.00 41.67 100.00 3.732.92 400 400 200 150 400 200 42 100 3,712 200 200 200 42 100 3.342 42 200 0 42 100 3.742 200 0 40 100 100 100 100 3,712 3.712 100 3,702 3,707 6,042 100 3.242 3.222 233 233 243 238 233 53 33 53 73 -385 -585 425 Difference (available for spending, saving, investing and donating Revolving savings withdrawals 0 0 0 0 0 0 0 0 385 58 Table 3-7 Cash-Flow Calendar for Harry and Belinda Johnson 3 Month January February March Surplus/ Deficit (1-2) $233 233 243 238 233 April May 1 Estimated Income $ 10,510 10,510 10,510 10,510 10,510 10,510 10,510 13,510 10,510 10,510 10,510 10,510 $129,120 2 Estimated Expenses $ 10,277 $ 10,277 10,267 10,272 10,277 10,507 10,457 13,477 10,457 10,437 10,895 11,095 $128,695 Cumulative Surplus/Deficit $ 233 $ 466 $ 709 $ 947 $1,180 $1,183 $1,236 $1,269 $1,322 $1,395 $1,010 $ 425 33 June July August September October November December Total 73 -385 --585 $425 5:05 111 11111 ***** SS Jan 3.7 Cash-Flow Calendar for and Belinda con Table 7-2 Monthly Installment Payments for a Loan (Principal and Interest Required to Repay $1,000*) 600 = Number of Monthly Payments APR* 12 24 36 48 60 72 84 5 $85.61 $43.87 $29.97 $23.03 $18.87 $16.10 $14.13 6 86.07 4 4.32 30.42 23.49 '19.33 16.57 14.61 86.53 44.77 30.88 23.95 19.80 17.05 15.09 86.99 45.23 31.34 24.41 20.28 17.53 15.59 87.45 45.68 31.80 24.88 20.76 1 8.03 16.09 87.92 46.14 32.27 25.36 21.25 18.53 16.60 88.38 46.61 32.74 25.85 21.74 19.03 17.12 88.85 47.07 33.21 26.33 22.24 19.55 17.65 89.32 47.54 33.69 26.83 22.75 20.07 18.19 89.79 48.01 34.18 27.33 23.27 20.61 18.74 90.26 48.49 34.67 27.83 23.79 21.14 19.27 90.73 48.96 3 5.16 28.34 24.32 21.69 19.86 91.20 49.44 35.65 28.85 24.85 22.25 20.44 18 91.68 49.92 36.15 29.37 25.39 22.81 21.02 19 9 2.16 50.41 36.66 29.90 25.94 23.38 21.61 20 92.63 50.90 37.16 30.43 26.49 23.95 22.21 To illustrate, assume an automobile loan of 514,000 at 8 percent for five years. To repay 51,000, the monthly payment is 520.28; therefore, multiply $20.28 (8% row and 60-month column) by 14 to give a monthly payment of $283.92. For amounts other than exact 51.000 increments, simply use decimals. For example, for a loan of $14.500. the multiplier would be 14.5 "For fractional interest rates of 5.5.6.5, 7.5, and so on, simply take a monthly payment halfway between the whole number APR payments. For example, the payment for 48 months at 9.5 percent is 525 12 525.36 50.48/2 - 50.24: 50.24 +524.88 524 88 = 50.48. $25.121 o u Bw Financial planning cases 7-1 The Johnsons' Credit Questions They are considering trading their car in for a newer used vehicle so that Harry can have dependable transportation for commuting to work. The couple still owes $5,310 to the credit union for their current car, or $295 per month for the remaining 18 months of the 48-month loan. The trade in value of this car plus $1,000 that Harry earned from a freelance interior design job should allow the couple to pay off the auto loan and leave $1,100 for a down payment on the newer car. The Johnsons have agreed on a sales price for the newer car of $16,000. The money planned for tires will be spent for other incidental taxes and fees associated with the purchase a. Make recommendations to Harry and Belinda regarding where to seek financing and what APR to expect. The input in the box below will not be graded, but may be reviewed and considered by your instructor blank b. Using the Garman/Forgue companion website or the information in Table 7-2, calculate the monthly payment for a loan period of three, four, five, and six years at 7 percent APR. Round your answers to the nearest cent Round Monthly Installment Payment for a Loan in intermediate calculations to the nearest cent. For a 3-year loan $ For a 4-year loan: S For a 5-year loan: $ For a 6-year loan $ Describe the relationship between the loan period and the payment amount The input in the box below will not be graded, but may be reviewed and considered by your instructor Table 7-2 Monthly Installment Payments for a Loan (Principal and Interest Required to Repay $1,000*) APR 5 6 7 12 $85.61 86.07 86.53 86.99 87.45 87.92 88.38 88.85 89.32 89.79 90.26 90.73 91.20 91.68 9 2.16 92.63 Number of Monthly Payments 24 36 48 60 $43.87 $29.97 $23.03 $18.87 44.32 30.42 23.49 19.33 44.77 30.88 23.95 19.80 45.23 31.34 24.41 20.28 45.68 31.80 2 4.88 20.76 46.14 32.27 25.36 21.25 46.61 32.74 25.85 21.74 47.07 33.21 2 6.33 22.24 47.54 26.83 22.75 48.01 34.18 27.33 23.27 48.49 34.67 27.83 23.79 48.96 35.16 28.34 24.32 49.44 35.65 28.85 24.85 49.92 36.15 29.37 25.39 50.41 36.66 29.90 25.94 50.90 37.16 30.43 26.49 72 $16.10 16.57 17.05 17.53 18.03 18.53 19.03 19.55 20.07 20.61 21.14 21.69 22.25 22.81 23.38 23.95 184 $14.13 14.61 15.09 15.59 16.09 16.60 17.12 17.65 18.19 18.74 19.27 19.86 20.44 21.02 21.61 22.21 19 20 To illustrate, assume an automobile loan of $14,000 at 8 percent for five years. To repay $1,000, the monthly payment is $20.28, therefore, multiply $20.28 (8% row and 60-month column) by 14 to give a monthly payment of $283.92. For amounts other than exact $1,000 increments, simply use decimals. For example, for a loan of $14,500, the multiplier would be 14.5. For fractional interest rates of 5.5, 6.5, 7.5, and so on, simply take a monthly payment halfway between the whole number APR payments. For example, the payment for 48 months at 9.5 percent is $25.12 (525.36 - $24.88 = 50.48; $0.48/2 = $0.24; 50.24 + $24.88 = $25.12). blank c. Harry and Belinda have a cash-flow deficit projected for several months this year (see Table 3-6 and Table 3-7). Suggest how, when, and where they might finance the shortages by borrowing. The input in the box below will not be graded, but may be reviewed and considered by your instructor blank Table 3-6 2018 Unfinished Annual Budget Estimates for Harry and Belinda Johnson Jan Feb Mar Apr May June July Aug. Sept. Oct Nov Dec Yearly Total Monthly Averages 4,080 4,080 4,080 6,400 6,400 6,400 30 30 30 0 0 0 10,510 10,510 10,510 4,080 6,400 30 0 10,510 4,080 6,400 30 0 10,510 4,080 6,400 30 0 10,510 4.0804,080 6,400 6,400 30 30 0 3,000 10,510 13,510 4,080 6,400 30 0 10,510 4,080 6,400 30 0 10,510 4,080 6,400 30 0 10,510 4,080 6,400 30 0 10,510 48,960 76,800 360 3,000 129,120 4,080.00 6,400.00 30.00 250.00 10,760.00 1,600 1,600 1,600 1,700 1,600 300 20 1,700 350 20 1,700 350 1,600 300 20 0 0 0 20 1,700 350 20 500 0 1,700 350 20 500 0 0 500 0 220 o INCOME Harry's salary Belinda's salary Interest Income from trust TOTAL INCOME EXPENSES Fixed Expenses Rent Health insurance Life insurance Home purchase fund Renter's insurance Automobile insurance Auto loan payments Student loan payments Savings/emergencies Harry's retirement plan Belinda's retirement plan Cable TV and Internet Federal income taxes State income taxes Social security taxes Automobile registration Total fixed expenses Variable Expenses Savings money market Revolving savings fund Food (home) Food (out) 1,700 350 20 500 0 600 490 300 0 490 490 490 300 300 100 195 300 100 300 100 100 19,800 3,900 240 2,500 220 1,200 5,880 3,600 1,200 2,340 4,800 1.920 20,400 6,000 9,600 300 83,900 1,650.00 325.00 20.00 208.33 18.33 100.00 490.00 300.00 100.00 195.00 400.00 160.00 1,700.00 500.00 800.00 25.00 6,991.67 195 300 100 195 400 160 1.700 500 195 195 400 800 400 400 400 160 400 160 1,700 160 400 160 1.700 160 1,700 400 160 1.700 1,700 700 1,700 500 1,700 500 BOO 160 1.700 500 800 500 500 195 400 160 1.700 500 800 0 7,815 400 160 1.700 500 800 00 7,515 SOD 800 800 800 800 800 300 6,565 6,565 6,565 6,565 6,565 7.165 6,715 7.435 7,215 7,215 0 250 550 300 0 250 550 300 210 550 300 250 550 300 0 1900 550 550 300 300 400 3,000 2400 550 550 300 300 0 0 200190 550 550 300 300 0 0 550 300 0 0 550 300 3.400 1.780 6,600 3,600 283.33 148.33 550.00 300.00 550 550 550 550 300 550 300 550 300 220 550 300 220 550 300 220 110 550 300 220 220 110 550 300 220 110 220 100 6,600 3,600 2,640 1,320 2,640 1,200 550.00 300.00 220.00 110.00 220.00 100.00 110 220 100 220 100 170 100 300 Food (home) Food (out) Utilities Cell phones Auto gas repairs Doctor/dentist out-of-pocket Medicines Clothing and upkeep Church and charity Gifts Public transportation Personal allowances Entertainment European vacation Summer vacation Anniversary dinner party Miscellaneous Total variable expenses TOTAL EXPENSES Difference (available for spending, saving, investing, and donating Revolving savings withdrawals 720 2,040 1.160 1,475 1,920 6,000 1,800 3,600 1.200 500 1,200 44,795 60.00 170.00 96.67 122.92 160.00 500.00 150.00 300.00 100.00 41.67 100.00 3.732.92 400 200 42 100 3,712 100 100 3,712 200 0 40 100 3,280 100 3,702 42 100 3,342 100 3,712 42 100 3,742 40 100 3,380 100 100 6,0423,242 3,707 3,222 10.277 10,277 10,267 233 233 243 10,272 238 10,277 10,507 233 3 10,457 5 3 13,477 33 10.457 53 10,437 7 3 10,895 -385 11,095 -585 128,695 425 10,724.58 0 0 0 0 0 0 0 0 0 0 385 585 0 Table 3-7 Cash-Flow Calendar for Harry and Belinda Johnson Surplus/ Deficit (1-2) $233 233 243 238 Month January February March April May June July August September October November December Total Estimated Income $ 10,510 10,510 10,510 10,510 10,510 10,510 10,510 13,510 10,510 10,510 10,510 10,510 2 Estimated Expenses $ 10,277 $ 10,277 10,267 10,272 10,277 10,507 10,457 13,477 10,457 10,437 10,895 11,095 Cumulative Surplus/Deficit $ 233 $ 466 $ 709 $ 947 $1,180 $1,183 $1,236 $1,269 $1.322 $1,395 $1,010 $425 73 -385 -585 $425 Financial planning cases 7-1 The Johnsons' Credit Questions They are considering trading their car in for a newer used vehicle so that Harry can have dependable transportation for commuting to work. The couple still owes $5,310 to the credit union for their current car, or $295 per month for the remaining 18 months of the 48-month loan. The trade-in value of this car plus $1,000 that Harry earned from a freelance interior design job should allow the couple to pay off the auto loan and leave $1,100 for a down payment on the newer car. The Johnsons have agreed on a sales price for the newer car of $16,000. The money planned for tires will be spent for other incidental taxes and fees associated with the purchase a. Make recommendations to Harry and Belinda regarding where to seek financing and what APR to expect The input in the box below will not be graded, but may be reviewed and considered by your instructor blank b. Using the Garman/Forgue companion website or the information in Table 7-2, calculate the monthly payment for a loan period of three, four, five, and six years at 7 percent APR. Round your answers to the nearest cent Round Monthly installment Payment for a Loan in intermediate calculations to the nearest cent. For a 3-year loan: For a 4-year loan: $ For a 5-year loan: $ For a 6-year loan: $ Describe the relationship between the loan period and the payment amount The input in the box below will not be graded but may be reviewed and considered by your instructor The input in the box below will not be graded, but may be reviewed and considered by your instructor blank c. Harry and Belinda have a cash-flow deficit projected for several months this year (see Table 3-6 and Table 3-7). Suggest how, when, and where they might finance the shortages by borrowing, The input in the box below will not be graded, but may be reviewed and considered by your instructor blank Table 3-6 2018 Unfinished Annual Budget Estimates for Harry and Belinda Johnson Jan. Feb. Yearly Monthly Total Averages Mar Apr May June July Aug. Sept. Oct Nov Dec. INCOME Harry's salary Belinda's salary Interest Income from trust 4,080 6,400 4,080 4,080 4,080 6,400 6,400 6,400 30 30 30 0 0 0 10,510 10,510 10,510 4,080 6,400 30 0 10,510 4,080 6,400 30 0 10,510 4,00 6,400 30 0 10,510 4,00 6,400 30 0 10,510 4,080 6.400 30 3,000 13.510 4,080 6,400 30 4,080 6,400 30 4,080 6,400 30 0 10,510 48,960 76,800 360 3,000 129,120 4,080.00 6,400.00 30.00 250.00 10,760.00 10,510 10,510 10,510 1,700 1,600 300 1,600 300 19,800 3,900 20 240 0 2,500 220 300 EXPENSES Fixed Expenses Rent Health insurance Life insurance Home purchase fund Renter's insurance Automobile insurance Auto loan payments Student loan payments Savings/emergencies Harry retirement plan Belinda's retirement plan Cable TV and Internet Federal income taxes State income taxes Social security taxes Automobile registration Total fixed expenses Variable Expenses Savings money market Revolving savingsfund Food thome) Food Love 195 1,650.00 325.00 2000 208.33 18.33 100.00 490.00 300.00 100.00 195.00 400.00 160.00 1,700.00 500.00 800.00 25.00 6,991.67 500 0 600 490 300 100 195 400 160 1,700 500 800 0 7.815 400 400 100 400 400 160 160 1,200 5,880 3,600 1,200 2,340 4,800 1.920 20,400 6,000 9,600 300 83.900 400 160 1,700 160 160 1,700 500 1,700 160 1,700 400 160 1,700 500 BOD 1,700 500 300 700 700 160 1.700 500 300 SOO 400 160 1.700 500 BOD 300 7,515 500 300 800 0 6,715 6,565 6,565 0 7.215 5,565 6,565 6,565 7,165 7,215 3,000 0 250 550 300 0 250 550 0 0 0 210 550 300 250 550 300 0 190 550 300 0 0 550 300 400 240 550 300 550 300 550 300 190 550 300 550 300 550 300 3,400 70 5.600 3.600 148.33 550.00 300.00 550 550 550 550 550 300 550 300 220 300 300 300 550.00 300.00 220 110 220 110 5506,600 300 3,600 220 2,640 110 1,320 2,640 1,200 110 220 110.00 220.00 100.00 100 Food (home) Food (out) Utilities Cell phones Auto gas repairs Doctor/dentist out-of-pocket Medicines Clothing and upkeep Church and charity Gifts Public transportation Personal allowances Entertainment European vacation Summer vacation Anniversary dinner party Miscellaneous Total variable expenses 140 100 300 500 720 2,040 1.160 1,475 1,920 6,000 1,800 3,600 1,200 500 1.200 44,795 60.00 170.00 96.67 122.92 160.00 500.00 150.00 300.00 100.00 41.67 100.00 3.732.92 400 400 200 150 400 200 42 100 3,712 200 200 200 42 100 3.342 42 200 0 42 100 3.742 200 0 40 100 100 100 100 3,712 3.712 100 3,702 3,707 6,042 100 3.242 3.222 233 233 243 238 233 53 33 53 73 -385 -585 425 Difference (available for spending, saving, investing and donating Revolving savings withdrawals 0 0 0 0 0 0 0 0 385 58 Table 3-7 Cash-Flow Calendar for Harry and Belinda Johnson 3 Month January February March Surplus/ Deficit (1-2) $233 233 243 238 233 April May 1 Estimated Income $ 10,510 10,510 10,510 10,510 10,510 10,510 10,510 13,510 10,510 10,510 10,510 10,510 $129,120 2 Estimated Expenses $ 10,277 $ 10,277 10,267 10,272 10,277 10,507 10,457 13,477 10,457 10,437 10,895 11,095 $128,695 Cumulative Surplus/Deficit $ 233 $ 466 $ 709 $ 947 $1,180 $1,183 $1,236 $1,269 $1,322 $1,395 $1,010 $ 425 33 June July August September October November December Total 73 -385 --585 $425 5:05 111 11111 ***** SS Jan 3.7 Cash-Flow Calendar for and Belinda con Table 7-2 Monthly Installment Payments for a Loan (Principal and Interest Required to Repay $1,000*) 600 = Number of Monthly Payments APR* 12 24 36 48 60 72 84 5 $85.61 $43.87 $29.97 $23.03 $18.87 $16.10 $14.13 6 86.07 4 4.32 30.42 23.49 '19.33 16.57 14.61 86.53 44.77 30.88 23.95 19.80 17.05 15.09 86.99 45.23 31.34 24.41 20.28 17.53 15.59 87.45 45.68 31.80 24.88 20.76 1 8.03 16.09 87.92 46.14 32.27 25.36 21.25 18.53 16.60 88.38 46.61 32.74 25.85 21.74 19.03 17.12 88.85 47.07 33.21 26.33 22.24 19.55 17.65 89.32 47.54 33.69 26.83 22.75 20.07 18.19 89.79 48.01 34.18 27.33 23.27 20.61 18.74 90.26 48.49 34.67 27.83 23.79 21.14 19.27 90.73 48.96 3 5.16 28.34 24.32 21.69 19.86 91.20 49.44 35.65 28.85 24.85 22.25 20.44 18 91.68 49.92 36.15 29.37 25.39 22.81 21.02 19 9 2.16 50.41 36.66 29.90 25.94 23.38 21.61 20 92.63 50.90 37.16 30.43 26.49 23.95 22.21 To illustrate, assume an automobile loan of 514,000 at 8 percent for five years. To repay 51,000, the monthly payment is 520.28; therefore, multiply $20.28 (8% row and 60-month column) by 14 to give a monthly payment of $283.92. For amounts other than exact 51.000 increments, simply use decimals. For example, for a loan of $14.500. the multiplier would be 14.5 "For fractional interest rates of 5.5.6.5, 7.5, and so on, simply take a monthly payment halfway between the whole number APR payments. For example, the payment for 48 months at 9.5 percent is 525 12 525.36 50.48/2 - 50.24: 50.24 +524.88 524 88 = 50.48. $25.121 o u Bw Financial planning cases 7-1 The Johnsons' Credit Questions They are considering trading their car in for a newer used vehicle so that Harry can have dependable transportation for commuting to work. The couple still owes $5,310 to the credit union for their current car, or $295 per month for the remaining 18 months of the 48-month loan. The trade in value of this car plus $1,000 that Harry earned from a freelance interior design job should allow the couple to pay off the auto loan and leave $1,100 for a down payment on the newer car. The Johnsons have agreed on a sales price for the newer car of $16,000. The money planned for tires will be spent for other incidental taxes and fees associated with the purchase a. Make recommendations to Harry and Belinda regarding where to seek financing and what APR to expect. The input in the box below will not be graded, but may be reviewed and considered by your instructor blank b. Using the Garman/Forgue companion website or the information in Table 7-2, calculate the monthly payment for a loan period of three, four, five, and six years at 7 percent APR. Round your answers to the nearest cent Round Monthly Installment Payment for a Loan in intermediate calculations to the nearest cent. For a 3-year loan $ For a 4-year loan: S For a 5-year loan: $ For a 6-year loan $ Describe the relationship between the loan period and the payment amount The input in the box below will not be graded, but may be reviewed and considered by your instructor Table 7-2 Monthly Installment Payments for a Loan (Principal and Interest Required to Repay $1,000*) APR 5 6 7 12 $85.61 86.07 86.53 86.99 87.45 87.92 88.38 88.85 89.32 89.79 90.26 90.73 91.20 91.68 9 2.16 92.63 Number of Monthly Payments 24 36 48 60 $43.87 $29.97 $23.03 $18.87 44.32 30.42 23.49 19.33 44.77 30.88 23.95 19.80 45.23 31.34 24.41 20.28 45.68 31.80 2 4.88 20.76 46.14 32.27 25.36 21.25 46.61 32.74 25.85 21.74 47.07 33.21 2 6.33 22.24 47.54 26.83 22.75 48.01 34.18 27.33 23.27 48.49 34.67 27.83 23.79 48.96 35.16 28.34 24.32 49.44 35.65 28.85 24.85 49.92 36.15 29.37 25.39 50.41 36.66 29.90 25.94 50.90 37.16 30.43 26.49 72 $16.10 16.57 17.05 17.53 18.03 18.53 19.03 19.55 20.07 20.61 21.14 21.69 22.25 22.81 23.38 23.95 184 $14.13 14.61 15.09 15.59 16.09 16.60 17.12 17.65 18.19 18.74 19.27 19.86 20.44 21.02 21.61 22.21 19 20 To illustrate, assume an automobile loan of $14,000 at 8 percent for five years. To repay $1,000, the monthly payment is $20.28, therefore, multiply $20.28 (8% row and 60-month column) by 14 to give a monthly payment of $283.92. For amounts other than exact $1,000 increments, simply use decimals. For example, for a loan of $14,500, the multiplier would be 14.5. For fractional interest rates of 5.5, 6.5, 7.5, and so on, simply take a monthly payment halfway between the whole number APR payments. For example, the payment for 48 months at 9.5 percent is $25.12 (525.36 - $24.88 = 50.48; $0.48/2 = $0.24; 50.24 + $24.88 = $25.12). blank c. Harry and Belinda have a cash-flow deficit projected for several months this year (see Table 3-6 and Table 3-7). Suggest how, when, and where they might finance the shortages by borrowing. The input in the box below will not be graded, but may be reviewed and considered by your instructor blank Table 3-6 2018 Unfinished Annual Budget Estimates for Harry and Belinda Johnson Jan Feb Mar Apr May June July Aug. Sept. Oct Nov Dec Yearly Total Monthly Averages 4,080 4,080 4,080 6,400 6,400 6,400 30 30 30 0 0 0 10,510 10,510 10,510 4,080 6,400 30 0 10,510 4,080 6,400 30 0 10,510 4,080 6,400 30 0 10,510 4.0804,080 6,400 6,400 30 30 0 3,000 10,510 13,510 4,080 6,400 30 0 10,510 4,080 6,400 30 0 10,510 4,080 6,400 30 0 10,510 4,080 6,400 30 0 10,510 48,960 76,800 360 3,000 129,120 4,080.00 6,400.00 30.00 250.00 10,760.00 1,600 1,600 1,600 1,700 1,600 300 20 1,700 350 20 1,700 350 1,600 300 20 0 0 0 20 1,700 350 20 500 0 1,700 350 20 500 0 0 500 0 220 o INCOME Harry's salary Belinda's salary Interest Income from trust TOTAL INCOME EXPENSES Fixed Expenses Rent Health insurance Life insurance Home purchase fund Renter's insurance Automobile insurance Auto loan payments Student loan payments Savings/emergencies Harry's retirement plan Belinda's retirement plan Cable TV and Internet Federal income taxes State income taxes Social security taxes Automobile registration Total fixed expenses Variable Expenses Savings money market Revolving savings fund Food (home) Food (out) 1,700 350 20 500 0 600 490 300 0 490 490 490 300 300 100 195 300 100 300 100 100 19,800 3,900 240 2,500 220 1,200 5,880 3,600 1,200 2,340 4,800 1.920 20,400 6,000 9,600 300 83,900 1,650.00 325.00 20.00 208.33 18.33 100.00 490.00 300.00 100.00 195.00 400.00 160.00 1,700.00 500.00 800.00 25.00 6,991.67 195 300 100 195 400 160 1.700 500 195 195 400 800 400 400 400 160 400 160 1,700 160 400 160 1.700 160 1,700 400 160 1.700 1,700 700 1,700 500 1,700 500 BOO 160 1.700 500 800 500 500 195 400 160 1.700 500 800 0 7,815 400 160 1.700 500 800 00 7,515 SOD 800 800 800 800 800 300 6,565 6,565 6,565 6,565 6,565 7.165 6,715 7.435 7,215 7,215 0 250 550 300 0 250 550 300 210 550 300 250 550 300 0 1900 550 550 300 300 400 3,000 2400 550 550 300 300 0 0 200190 550 550 300 300 0 0 550 300 0 0 550 300 3.400 1.780 6,600 3,600 283.33 148.33 550.00 300.00 550 550 550 550 300 550 300 550 300 220 550 300 220 550 300 220 110 550 300 220 220 110 550 300 220 110 220 100 6,600 3,600 2,640 1,320 2,640 1,200 550.00 300.00 220.00 110.00 220.00 100.00 110 220 100 220 100 170 100 300 Food (home) Food (out) Utilities Cell phones Auto gas repairs Doctor/dentist out-of-pocket Medicines Clothing and upkeep Church and charity Gifts Public transportation Personal allowances Entertainment European vacation Summer vacation Anniversary dinner party Miscellaneous Total variable expenses TOTAL EXPENSES Difference (available for spending, saving, investing, and donating Revolving savings withdrawals 720 2,040 1.160 1,475 1,920 6,000 1,800 3,600 1.200 500 1,200 44,795 60.00 170.00 96.67 122.92 160.00 500.00 150.00 300.00 100.00 41.67 100.00 3.732.92 400 200 42 100 3,712 100 100 3,712 200 0 40 100 3,280 100 3,702 42 100 3,342 100 3,712 42 100 3,742 40 100 3,380 100 100 6,0423,242 3,707 3,222 10.277 10,277 10,267 233 233 243 10,272 238 10,277 10,507 233 3 10,457 5 3 13,477 33 10.457 53 10,437 7 3 10,895 -385 11,095 -585 128,695 425 10,724.58 0 0 0 0 0 0 0 0 0 0 385 585 0 Table 3-7 Cash-Flow Calendar for Harry and Belinda Johnson Surplus/ Deficit (1-2) $233 233 243 238 Month January February March April May June July August September October November December Total Estimated Income $ 10,510 10,510 10,510 10,510 10,510 10,510 10,510 13,510 10,510 10,510 10,510 10,510 2 Estimated Expenses $ 10,277 $ 10,277 10,267 10,272 10,277 10,507 10,457 13,477 10,457 10,437 10,895 11,095 Cumulative Surplus/Deficit $ 233 $ 466 $ 709 $ 947 $1,180 $1,183 $1,236 $1,269 $1.322 $1,395 $1,010 $425 73 -385 -585 $425