John and Daphne are saving for their daughter Ellen's college education. Ellen just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $14,500 a year, but they are expected to increase at a rate of 3.5% a year. Ellen should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t= 8, 9, 10, and 11). So far, John and Daphne have accumulated $14,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $5,000 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 9%. How large must the annual payments at t = 5, 6, and 7 be to cover Ellen's anticipated college costs? a. $3,326.86 b. $2,970.41 c. $2,584.26 d. $3,505.08 e. $2,881.30 >

John and Daphne are saving for their daughter Ellen's college education. Ellen just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $14,500 a year, but they are expected to increase at a rate of 3.5% a year. Ellen should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t= 8, 9, 10, and 11). So far, John and Daphne have accumulated $14,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $5,000 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 9%. How large must the annual payments at t = 5, 6, and 7 be to cover Ellen's anticipated college costs? a. $3,326.86 b. $2,970.41 c. $2,584.26 d. $3,505.08 e. $2,881.30 >

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

Michiko and Saul are planning to attend the same university next year. The university estimates tuition, books, fees, and living costs to be 12,000 per year. Michikos father has agreed to give her the 12,000 she needs to attend the university. Saul has obtained a job at the university that will pay him 14,000 per year. After discussing their respective arrangements, Michiko figures that Saul will be better off than she will. What, if anything, is wrong with Michikos thinking?
Dontrell and Hannah are saving for their daughter Kennedy's college education. Kennedy just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $12,500 a year, but they are expected to increase at a rate of 4.0% a year. Kennedy should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, Dontrell and Hannah have accumulated $8,000 in their college savings account (at t = o). Their long-run financial plan is to add an additional $4,500 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 8%. How large must the annual payments at t = 5, 6, and 7 be to cover Kennedy's anticipated college costs? O a. $7,263.16…
Elijah and Laila are saving for their daughter Tanisha's college education. Tanisha just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $15,500 a year, but they are expected to increase at a rate of 4.0% a year. Tanisha should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11).So far, Elijah and Laila have accumulated $17,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $6,000 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 7%. How large must the annual payments at t = 5, 6, and 7 be to cover Tanisha's anticipated college costs?
Shemar and Candice are saving for their daughter Laila's college education. Laila just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $16,00o a year, but they are expected to increase at a rate of 3.5% a year. Laila should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, Shemar and Candice have accumulated $15,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $5,500 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 10%. How large must the annual payments at t = 5, 6, and 7 be to cover Laila's anticipated college costs? O a. $2,079.12 O b.…
James and Tanisha are saving for their daughter Nalah's college education. Nalah just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $16,000 a year, but they are expected to increase at a rate of 3.5% a year. Nalah should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, James and Tanisha have accumulated $14,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $6,000 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 10%. How large must the annual payments at t = 5, 6, and 7 be to cover Nalah's anticipated college costs? O a. $3,501.99 O O b.…
Joseph and Makena are saving for their daughter Dalia's college education. Dalia just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $15,500 a year, but they are expected to increase at a rate of 3.5% a year. Dalia should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11).So far, Joseph and Makena have accumulated $14,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $4,500 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 10%. How large must the annual payments at t = 5, 6, and 7 be to cover Dalia's anticipated college costs? a. $3,178.71…
Jelani and Angel are saving for their daughter Candice's college education. Candice just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $14.500 a year, but they are expected to increase at a rate of 4.0% a year. Candice should graduate in 4 years--if she takes longer or wants to go to graduate chool, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t= 8, 9, 10, and 11). 30 far, Jelani and Angel have accumulated $8,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $4,500 in each of the next 4 years (at t = 1, 2, 3 ind 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 10%. How large must the annual payments at t = 5, 6, and 7 be to cover Candice's anticipated college costs? O a. $6.973.29 O b.…
Jeremiah and Taylor are saving for their daughter Ciara's college education. Ciara just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $15,000 a year, but they are expected to increase at a rate of 2.5% a year. Ciara should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, Jeremiah and Taylor have accumulated $10,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $4,000 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 9%. How large must the annual payments at t = 5, 6, and 7 be to cover Ciara's anticipated college costs? a. $6,955.08 b.…
Cameron and Diamond are saving for their daughter Candice's college education. Candice just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $16,500 a year, but they are expected to increase at a rate of 4.0% a year. Candice should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, Cameron and Diamond have accumulated $10,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $5,500 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 9%. How large must the annual payments at t = 5, 6, and 7 be to cover Candice's anticipated college costs? O a.…
Matthew and Imani are saving for their daughter Ciana's college education. Ciana just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $13,000 a year, but they are expected to increase at a rate of 4.5% a year. Ciana should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, Matthew and Imani have accumulated $9,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $6,000 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 10%. How large must the annual payments at t = 5, 6, and 7 be to cover Ciana's anticipated college costs? a. $4,224.81 b. $2,575.22…
Justin and Kennedy are saving for their daughter Aliyah's college education. Aliyah just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $15,000 a year, but they are expected to increase at a rate of 2.5% a year. Aliyah should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, Justin and Kennedy have accumulated $10,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $5,500 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 8%. How large must the annual payments at t = 5, 6, and 7 be to cover Aliyah's anticipated college costs? a. $5,960.00 b.…
Nathan and Jordan are saving for their daughter Kaliah's college education. Kaliah just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $14,500 a year, but they are expected to increase at a rate of 3.5% a year. Kaliah should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, Nathan and Jordan have accumulated $12,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $5,500 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 10%. How large must the annual payments at t = 5, 6, and 7 be to cover Kaliah's anticipated college costs? O a. $3,779.16 O b.…