NOTE: Both Excel and Manual (calculator) processes are explained below, but we will use just processes (but feel free to trythe other..) Please set up below by identifying the given yanables and referencing those Cells (not the values) in your formulas injlet daughlers' college education in 20 years. How much (PV) should he contribute toward a CD that 23. Fuare Value Loan shark. Tarks leat $10,000 ( inowm PY) at 20% per month to developer, Alberto to bube land 24 appraiser, Julia so be may secure a loan from tanker, Wilhelm. How much (FV) will Alberto owe Tans 30 Manuify series af payments (imversog. receiving, of paying down a deba) Mowat fof 10 Yean (120) Mowthik but she shoveted "il"s my money and I wast it mow|" Assuming a to buy a moped; she is also musking mosthly contrite icus to a moeny market fief a dorky, electric, car. Over 5 years \{60 Montsi) how winch will she pay per moeath to satisfy each objectove? Q2. Iternal Rate af Reem An intial imvestanent of $250.000 reterns the following at the end of yearn 1-5: 6i7. (900) Exvcel nesed) $50,000;$60,000;$0,000;$80,000; and $60,000 Wi What is the Rate of Retum on the investment? 66 GIVEN: outflow inflow z+1 inflow inflow y3 inflow inflow 2 ins 67 b BRR : Heasy of forcossibilycintestigute NOTE: Both Excel and Manual (calculator) processes are explained below, but we will use just processes (but feel free to trythe other..) Please set up below by identifying the given yanables and referencing those Cells (not the values) in your formulas injlet daughlers' college education in 20 years. How much (PV) should he contribute toward a CD that 23. Fuare Value Loan shark. Tarks leat $10,000 ( inowm PY) at 20% per month to developer, Alberto to bube land 24 appraiser, Julia so be may secure a loan from tanker, Wilhelm. How much (FV) will Alberto owe Tans 30 Manuify series af payments (imversog. receiving, of paying down a deba) Mowat fof 10 Yean (120) Mowthik but she shoveted "il"s my money and I wast it mow|" Assuming a to buy a moped; she is also musking mosthly contrite icus to a moeny market fief a dorky, electric, car. Over 5 years \{60 Montsi) how winch will she pay per moeath to satisfy each objectove? Q2. Iternal Rate af Reem An intial imvestanent of $250.000 reterns the following at the end of yearn 1-5: 6i7. (900) Exvcel nesed) $50,000;$60,000;$0,000;$80,000; and $60,000 Wi What is the Rate of Retum on the investment? 66 GIVEN: outflow inflow z+1 inflow inflow y3 inflow inflow 2 ins 67 b BRR : Heasy of forcossibilycintestigute