12:18 Done Bond-valuation problems_f20... Vino Company raised capital to build a new frillabator factory in Donut Plaines, Iowa, and issued S200,000,000 of 20-year, 5.6% notes on October 1, 2019. The entire issue sold out on opening day, even after the firm's financial advisors adjusted the note price because of favorable news about firm prospects. The notes were priced to yield 4.5% when held to maturity What did each note sell for? Present your computations either by writing out the PV and PVA formulac, and using your calculators, or by using Excel Separate and price BOTH the Redemption and Annuity values. Lc, give the PV of the S200 million Redemption, give the PV of the 40 Annuity payments Give the journal entry to record the sale of the notes on October 1, 2019. Prepare an Amortization Schedule for the Premium. At maturity, the Premium sb equal to zero. You will need to adjust the final payment so the carrying value of the bonds quals S200 million Lucy Lockett bought three notes at issue date. On April 2, 2022 she decided to sell one note to finance some purchases for her trousseau. If the market rate for notes of Vino's ilk was then 6.0%, how much cash would she receive before paying commission? Derick Preuss is considering the purchase of a 2018 Slobinu PZX After trading in his 2013 Trombona-12 and paying $2,000, he would owe $29,508. Given his 821 FICO score, Chase Finance will finance his car for five years at 3.8% What will his monthly payments be? (First, use PMT in Excel; then, solve for A in the PVAcquation--cf. the **Calculator_bondvaluation" file I provided) Use Excel to prepare a Loan Amortization Schedule for the Chase loan. Assume an ordinary annuity. The first payment is due one month after initiation. Make sure to adjust the final payment so as to reach a final balance of zero. 12:18 Done Bond-valuation problems_f20... Vino Company raised capital to build a new frillabator factory in Donut Plaines, Iowa, and issued S200,000,000 of 20-year, 5.6% notes on October 1, 2019. The entire issue sold out on opening day, even after the firm's financial advisors adjusted the note price because of favorable news about firm prospects. The notes were priced to yield 4.5% when held to maturity What did each note sell for? Present your computations either by writing out the PV and PVA formulac, and using your calculators, or by using Excel Separate and price BOTH the Redemption and Annuity values. Lc, give the PV of the S200 million Redemption, give the PV of the 40 Annuity payments Give the journal entry to record the sale of the notes on October 1, 2019. Prepare an Amortization Schedule for the Premium. At maturity, the Premium sb equal to zero. You will need to adjust the final payment so the carrying value of the bonds quals S200 million Lucy Lockett bought three notes at issue date. On April 2, 2022 she decided to sell one note to finance some purchases for her trousseau. If the market rate for notes of Vino's ilk was then 6.0%, how much cash would she receive before paying commission? Derick Preuss is considering the purchase of a 2018 Slobinu PZX After trading in his 2013 Trombona-12 and paying $2,000, he would owe $29,508. Given his 821 FICO score, Chase Finance will finance his car for five years at 3.8% What will his monthly payments be? (First, use PMT in Excel; then, solve for A in the PVAcquation--cf. the **Calculator_bondvaluation" file I provided) Use Excel to prepare a Loan Amortization Schedule for the Chase loan. Assume an ordinary annuity. The first payment is due one month after initiation. Make sure to adjust the final payment so as to reach a final balance of zero