Answer Questions 5-7 and input data where necessary. Thank You?

Insert data in "Green Highlighted Cells" and formulas in "Yellow Highlighted Cells". The cell to the right of the "Yellow Highlighted Cell" where you insert your formula,

Writing on paper is fine

Penctice.5:- Solving for Puyment. PJDo Sntar. Problem PV n= Number of Periods I= rate PMT I borrow $100,000 to be repaid in ten equal annual installments. If the interest rate is 8% paid annually, what is the installment amount? Practice 6. Solvins for EV with Mrultiole Cash.Jows PMT(rate, nper, pv,fv, type) Syntax Problem Anna is 20 years old. She starts investing $1,000 every year in a bank PMT FV(rate,nper,pmt,pv,type) 45 years? n= Number of Periods I rate FV Formula Practice.7: Solving for the Monthly. Installment (PUD- Syntax I take a home loan of $100,000 to be repaid in thirty years or (1230= 360)360 equal monthly installments. If the interest rate is 6% paid PMT(rate,nper,pv,fv,type) monthly, what is the installment amount? n=NumberofPeriodsI=rate PMT