P Q Year 1 $457 3 4 5 7 8 9 A33 fx Factor in starting balance, investment earnings Pre-tax, tax costs, investment earnings net, premium due, and ending balance. B C D E F G H 1 J K L M N 0 1 Mark Gunn's life is changing dramatically. He and his wife Jen Premium 2 recently bought a duplex apartment in Worcester and are epecting their third child. Due 3 These new responsibilities have prompted Mark to think about some serious issues, $423 4 including life insurance 2 5 $489 6 10 years ago, Mark sold his drums and purchased an insurance policy that provides a death benefit of $4 $516 7 This policy is paid in full and will remain in effect for the rest of Mark's life. $530 8 Alternately, Mark can cash in the policy and receive an immediate payoff of $6,000 6 $558 9 from the insurance company $595 10 $618 11 10 years ago. $40.000 seemed like it was enough. Now, he's not so sure $660 12 Mark is investiagting a different insurance product hat would provide a death benefit 10 $716 13 of $350.000 but he and Jen would need to make ongoing monthly payments. 14 15 The table to the right shows the annual premiums for the new policy 16 'over the next 10 years . 17 18 To pay the premiums for the new policy. Mark had an idea, the first good idea 19 of his lite He could cash out the existing policy, take the $6,000 and invest it 20 Using the after tax proceeds from the investment, he could then pay the premium on the new policy 21 22 However to see if this is possible, he wants to understand the minimum rate of return 23 that he would have to earn from this investment to be able to cover the after-tax Premium payments 24 25 His tax rate is 28% 26 27 a. Calculate the Investment earnings for each of the next 10 years, if the Annual Return is 15%. 28 'The Annual interest is compounded quarterly 29 Be sure to factor in that Mark would owe taxes on these earnings 30 The formula for the annual interest earned, if it's compounded quarterly is 31 = Beginning Balance *(1+Interest Rate / 414 Beginning Balance 32 33 Factor in starting balance, investment eamings Pre-tax, tax costs, investment earnings net, premium due and ending balance 34 35 bUsing Solver, what's the minimum Annual retum that Mark would need to 36 ensure he can cover his premium payments using after-tax earnings from the investment of the OK? 37 Use GRG Non-Linear P Q Year 1 $457 3 4 5 7 8 9 A33 fx Factor in starting balance, investment earnings Pre-tax, tax costs, investment earnings net, premium due, and ending balance. B C D E F G H 1 J K L M N 0 1 Mark Gunn's life is changing dramatically. He and his wife Jen Premium 2 recently bought a duplex apartment in Worcester and are epecting their third child. Due 3 These new responsibilities have prompted Mark to think about some serious issues, $423 4 including life insurance 2 5 $489 6 10 years ago, Mark sold his drums and purchased an insurance policy that provides a death benefit of $4 $516 7 This policy is paid in full and will remain in effect for the rest of Mark's life. $530 8 Alternately, Mark can cash in the policy and receive an immediate payoff of $6,000 6 $558 9 from the insurance company $595 10 $618 11 10 years ago. $40.000 seemed like it was enough. Now, he's not so sure $660 12 Mark is investiagting a different insurance product hat would provide a death benefit 10 $716 13 of $350.000 but he and Jen would need to make ongoing monthly payments. 14 15 The table to the right shows the annual premiums for the new policy 16 'over the next 10 years . 17 18 To pay the premiums for the new policy. Mark had an idea, the first good idea 19 of his lite He could cash out the existing policy, take the $6,000 and invest it 20 Using the after tax proceeds from the investment, he could then pay the premium on the new policy 21 22 However to see if this is possible, he wants to understand the minimum rate of return 23 that he would have to earn from this investment to be able to cover the after-tax Premium payments 24 25 His tax rate is 28% 26 27 a. Calculate the Investment earnings for each of the next 10 years, if the Annual Return is 15%. 28 'The Annual interest is compounded quarterly 29 Be sure to factor in that Mark would owe taxes on these earnings 30 The formula for the annual interest earned, if it's compounded quarterly is 31 = Beginning Balance *(1+Interest Rate / 414 Beginning Balance 32 33 Factor in starting balance, investment eamings Pre-tax, tax costs, investment earnings net, premium due and ending balance 34 35 bUsing Solver, what's the minimum Annual retum that Mark would need to 36 ensure he can cover his premium payments using after-tax earnings from the investment of the OK? 37 Use GRG Non-Linear