excel assi 2 - Total Day care fee Total Expenses Total...

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Question 3 Assumption: 2. RESP's Grant is $400 per year. The tuition fee will be paid by semi-annual. a) Day Care Fee: Age 2-5 PMT: -750 I: 0.245 (2.94/12) n: 48 FV: $38,152.76 Total Day care fee: $38,152.76 Exepenses: Age 1-5 PMT: -750 I: 0.245% n: 60 FV: $48,411.96 Age 5-10 PMT: -1439 I: 0.245% n: 60 PV: $80,202.70 Age 10-15 PMT: -1420 I: 0.245% n: 60 PV: $79,143.73 $68,469.27 Age 15-18 PMT: -1330 I: 0.245% n: 36 PV: $45,775.61 $34,260.40 Age 18-22 PMT: -750 I: 0.245% n: 48 PV: $33,924.65 $23,276.69 Total Expenses: $254,621.02 University Tuition(18-22): PMT: -5000 I: 1.470% 0.0294/2 n: 8 PV: $37,478.59 $25,715.15 We should deduct RESP from her total cost. The period is 13 years.(5-18) We assume the RESPP's grant is $400 per year. PMT: -400 I: 2.94% n: 13 PV: $4,270.35 Total Cost for Pebbles until she completes university:
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Total Day care fee+Total Expenses+Total university tuition-RESP's grant= $314,218.58 b) private schooling fee: PMT:-$24,996.00 2083*12 I: 2.940% n: 12 PV: $249,703.80 Total cost for pebbles= $563,922.38 1. Real interest rate is 2.94% per year 3. Pebbles will go to school in this year. The other words, she just is 6 now. 4. Pebble’s day care fee will be paid by monthly. 5. Pebble’s university tuition fee is $5,000 per year for a 4 years’ degree. 6. When Pebble was to include private schooling, the tuition fee will be paid by annual. 7. The point of present value cost is that Pebbles starts 6 years old. PV 5(2.94%,5ys,)= PV' 6(2.94%, 10ys)= PV'' 6(2.94%, 13)= PV''' 6(2.94%,13ys)=...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern