please explain step by step how to prepare bond pricing and amortization . thank you

LEARNENA OBUECTVES intevent metwods of ancritution - Une the unirV tumction. - Cactutate bond prices ather issuasce. - Interpret the relationstip betmeen bond prices and yoars to matuety. - Ater the workeneet to accommodase bonds with ep to 20 yers mataity. - Create a chart ploting the annual interest espense under toth the strapptesire ard effectie riterest methods PROBLEM DATA The Unwerety Club recently issued $1,500,000 of 10 year, in, bords at an effective inserest tate of 107 . Bond interest is payable annually. REOUREMENT 1. You have been asked to calculate the issuance price of the bonds and prepare amicization schedules for any discount or premium. The workcheet BONDS has been provided to assist you. Note that the worksheet contains a soratch pad at the tottom that has been preprogrammed to automatically compute and display the relevant cash flows needed for bond pricing. 2. The bond pricing formula utilzes the NPV (Net Present Value) function on your spreadsheet program. The formula is broken into two parts as identifed by the letters in parentheses above the formula. See Appendox A in Ercel Quick for a discasson on the NPV function, and then explain the meaning of each part of the formula. FORMULA1: =NPV(E10,C60.C71) a. b. a. Guoud proq 1Nan34no3d 170 n37e0ed ouensst fitide sooud puod wnyent? uorpury RdVe ar ase uosertuour prooule seiest S3Muozrgo onsagrat (SONOE) NOLIVZL1UOV aNV DNISIHd ONOG 4 IN IN305 LEARNENA OBUECTVES intevent metwods of ancritution - Une the unirV tumction. - Cactutate bond prices ather issuasce. - Interpret the relationstip betmeen bond prices and yoars to matuety. - Ater the workeneet to accommodase bonds with ep to 20 yers mataity. - Create a chart ploting the annual interest espense under toth the strapptesire ard effectie riterest methods PROBLEM DATA The Unwerety Club recently issued $1,500,000 of 10 year, in, bords at an effective inserest tate of 107 . Bond interest is payable annually. REOUREMENT 1. You have been asked to calculate the issuance price of the bonds and prepare amicization schedules for any discount or premium. The workcheet BONDS has been provided to assist you. Note that the worksheet contains a soratch pad at the tottom that has been preprogrammed to automatically compute and display the relevant cash flows needed for bond pricing. 2. The bond pricing formula utilzes the NPV (Net Present Value) function on your spreadsheet program. The formula is broken into two parts as identifed by the letters in parentheses above the formula. See Appendox A in Ercel Quick for a discasson on the NPV function, and then explain the meaning of each part of the formula. FORMULA1: =NPV(E10,C60.C71) a. b. a. Guoud proq 1Nan34no3d 170 n37e0ed ouensst fitide sooud puod wnyent? uorpury RdVe ar ase uosertuour prooule seiest S3Muozrgo onsagrat (SONOE) NOLIVZL1UOV aNV DNISIHd ONOG 4 IN IN305