**100% money back guarantee**read our guarantees

- September 13, 2020
- By menge

Microsoft Word – Question for Cash Flow Case.docx

Question for Cash Flow Case

Calculate the present value

- Four years of continuous study
- You begin the study in Jan 1
- Tuition fee for each year is $40,000, paid out semiannually at June 30 and Dec 31 of each year
- Other expenses are estimated to be $18,000 per year, paid out monthly at the end of each month.
- You receive $5,000 of scholarship in the June 30 of the second year, and another $10,000 of scholarship in the Dec 31 of the third year
- Interest rate is 5% per year
- Calculate the present value of all the education cost. ( use formula, or show your work in Excel)