You may use your financial calculator or excel for calculationsbut be sure to show your work (i.e. rate, periods, payments, etc.).For the amortization schedules be sure to print the schedule so allcolumns fit on one page. For amortization schedules required forquestion 4 d. and f. only include the first and last pages of eachof the schedules.
1) Chris Hogan just found out he won $1,000,000 from thelottery. He has two options for receiving the prize. First, if hetakes the money today, the state and federal government will takeout 47% immediately. His second option is to receive a payout of 20equal installments of $72,000 with the first payment occurring whenChris turns in the winning ticket. Each of these payments will betaxed at a combined state and federal rate of 27%. Assuming Chriscan earn a 4% rate of return on any money invested during thisperiod, which option should he choose? Why? Show your work.
2)Malcolm Mitchell is the sole proprietor of MitchellEnterprises. He is exploring the option of going publicbecause his company is growing exponentially. The consulting firmthat is reviewing her financials has questioned whether MitchellâsCFO is technically competent enough to be the CFO of a publicallytraded company, as they believe he made several bad financialdecisions. The two situations, which the firm brings to Malcomâsattention, are as follows:
a) Mitchell purchased the building in which their corporateoffice is housed on 1/1/10 for $7,800,000. They putdown $2,000,000 cash and had to borrow the remaining amount at 8%over a 20-year term. At the time of the purchase, they had theoption to lease the building. The 20-year lease would begin on1/1/10, and called for payments of $600,000 beginning on that datefor the first 10 years and payments of $500,000 beginning on 1/1/20for the remaining 10 years of the lease. Mitchell had the option topurchase the building for $1 on December 31, 2029 at the end of thelease. Did the CFO make the right decision by purchasing thebuilding? Why or why not? Show your work.
b) This year, the company sold land for a non-interest bearingnote. The note calls for annual payments of $10,000 for 4 years.The payments will begin one year from the date of the sale. Anappropriate rate of interest for this type of note is 6%. The landhad an original purchase cost of $25,000. The CFO told theaccounting department to record the sale as follows:
(debit ) Notes Receivable $40,000
(credit) Land $25,000
(credit) Gain on Sale ofLand $15,000
Was this entry correct? If not, provide the correct entry.
3) James White loans Dion Lewis $550,000. White accepts a 4%note, which requires semiannual interest payments for 10 years. Theday after receiving the 4th interest payment, Whitedecides to sell the note to Dedham Savings Bank. Dedham SavingsBank agrees to purchase it to yield a 6% return.
a) What is the amount that James White will receive on the saleof the note to Dedham Savings Bank?
b) Prepare the entries that James White and Dedham Savings Bankwill make on the day the note is sold to the bank.
4) Jacoby Brissett is interested in buying a waterfront vacationhome and has saved $100,000 for the down payment. His plans callfor making additional monthly deposits into an investment accountover the next 12 months. Jacoby Brissett wants to make the purchase18 months from today and wants to have $400,000 saved up for thedown payment.
a) What is the amount of each of the additional payments he mustmake for his plan to work out? Assume Jacoby can earn4% annual return in his investment account.
b) Prepare an amortization schedule proving the answer youcomputed in a. is correct.
c) If Jacoby takes out a 30-year, $800,000 mortgage at 4%, whatwill his mortgage payments be?
d) Prepare an amortization schedule to prove that your answer isright and his mortgage will be paid off in 30 years.
e) Assume he pays an additional $500 towards his mortgage eachmonth. How much sooner will he be able to pay off her mortgage?
f) Prepare an amortization schedule proving your answer ine.
You may use your financial calculator or excel for calculationsbut be sure to show your work (i.e. rate, periods, payments, etc.).For the amortization schedules be sure to print the schedule so allcolumns fit on one page. For amortization schedules required forquestion 4 d. and f. only include the first and last pages of eachof the schedules.
1) Chris Hogan just found out he won $1,000,000 from thelottery. He has two options for receiving the prize. First, if hetakes the money today, the state and federal government will takeout 47% immediately. His second option is to receive a payout of 20equal installments of $72,000 with the first payment occurring whenChris turns in the winning ticket. Each of these payments will betaxed at a combined state and federal rate of 27%. Assuming Chriscan earn a 4% rate of return on any money invested during thisperiod, which option should he choose? Why? Show your work.
2)Malcolm Mitchell is the sole proprietor of MitchellEnterprises. He is exploring the option of going publicbecause his company is growing exponentially. The consulting firmthat is reviewing her financials has questioned whether MitchellâsCFO is technically competent enough to be the CFO of a publicallytraded company, as they believe he made several bad financialdecisions. The two situations, which the firm brings to Malcomâsattention, are as follows:
a) Mitchell purchased the building in which their corporateoffice is housed on 1/1/10 for $7,800,000. They putdown $2,000,000 cash and had to borrow the remaining amount at 8%over a 20-year term. At the time of the purchase, they had theoption to lease the building. The 20-year lease would begin on1/1/10, and called for payments of $600,000 beginning on that datefor the first 10 years and payments of $500,000 beginning on 1/1/20for the remaining 10 years of the lease. Mitchell had the option topurchase the building for $1 on December 31, 2029 at the end of thelease. Did the CFO make the right decision by purchasing thebuilding? Why or why not? Show your work.
b) This year, the company sold land for a non-interest bearingnote. The note calls for annual payments of $10,000 for 4 years.The payments will begin one year from the date of the sale. Anappropriate rate of interest for this type of note is 6%. The landhad an original purchase cost of $25,000. The CFO told theaccounting department to record the sale as follows:
(debit ) Notes Receivable $40,000
(credit) Land $25,000
(credit) Gain on Sale ofLand $15,000
Was this entry correct? If not, provide the correct entry.
3) James White loans Dion Lewis $550,000. White accepts a 4%note, which requires semiannual interest payments for 10 years. Theday after receiving the 4th interest payment, Whitedecides to sell the note to Dedham Savings Bank. Dedham SavingsBank agrees to purchase it to yield a 6% return.
a) What is the amount that James White will receive on the saleof the note to Dedham Savings Bank?
b) Prepare the entries that James White and Dedham Savings Bankwill make on the day the note is sold to the bank.
4) Jacoby Brissett is interested in buying a waterfront vacationhome and has saved $100,000 for the down payment. His plans callfor making additional monthly deposits into an investment accountover the next 12 months. Jacoby Brissett wants to make the purchase18 months from today and wants to have $400,000 saved up for thedown payment.
a) What is the amount of each of the additional payments he mustmake for his plan to work out? Assume Jacoby can earn4% annual return in his investment account.
b) Prepare an amortization schedule proving the answer youcomputed in a. is correct.
c) If Jacoby takes out a 30-year, $800,000 mortgage at 4%, whatwill his mortgage payments be?
d) Prepare an amortization schedule to prove that your answer isright and his mortgage will be paid off in 30 years.
e) Assume he pays an additional $500 towards his mortgage eachmonth. How much sooner will he be able to pay off her mortgage?
f) Prepare an amortization schedule proving your answer ine.
