Required: Provide input into cells shaded in yellow in this template, Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. a. Prepare a bond premium amortization table for Lal, assuming Lai uses the effective interest method required by IFRS. b. Prepare journal entries to record the initial imestment, receipt of interest, and recognition of interest income in each of the three years, and the maturity of the bond at the end of the third year. Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. a. Prepare a bond premlum amortization table for Lai, assuming Lai uses the effective interest method required by IFRS. b. Prepare joumal entries to record the initial investment, receipt of interest, and recosnition of interest income in each of the three years, and the maturity of the band at the end of the third year. End of Year 1 End of Year 2 End of Year 3 (To record interest collected) (To record maturity of bond investment) f. Determine the present value of the bond using the NPV formula. End of Year 2 End of Year 3 (To record interest collected) (To record maturity of bond investment) f. Determine the present value of the bond using the NPV formula. Present value of the bond Required: Provide input into cells shaded in yellow in this template, Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. a. Prepare a bond premium amortization table for Lal, assuming Lai uses the effective interest method required by IFRS. b. Prepare journal entries to record the initial imestment, receipt of interest, and recognition of interest income in each of the three years, and the maturity of the bond at the end of the third year. Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. a. Prepare a bond premlum amortization table for Lai, assuming Lai uses the effective interest method required by IFRS. b. Prepare joumal entries to record the initial investment, receipt of interest, and recosnition of interest income in each of the three years, and the maturity of the band at the end of the third year. End of Year 1 End of Year 2 End of Year 3 (To record interest collected) (To record maturity of bond investment) f. Determine the present value of the bond using the NPV formula. End of Year 2 End of Year 3 (To record interest collected) (To record maturity of bond investment) f. Determine the present value of the bond using the NPV formula. Present value of the bond