Fill in all the red forms. Only the pv, fv, pmt formulas in excel can be used.
Fantastic news! We've Found the answer you've been seeking!
Question:
Fill in all the red forms. Only the pv, fv, pmt formulas in excel can be used. No other formulas can be used, all red forms must be completed
Transcribed Image Text:
AB C PV of Total Tuition Annual Deposit Amount Q1 Henry Spencer is interested in saving money to put his son, Shawn, through college. Shawn is turning 9 years old today, and Henry wants to be able to deposit an equal amount into a savings account each birthday until Shawn turns 21. He wants the deposits to be just large enough to pay for all 4 years of Shawn's education, and he plans to make the first deposit in a year. You can assume that tuition payments will be made on Shawn's 18th through 21st birthdays. You can also assume that the current cost of tuition is $14,500 a year, and that the cost will increase by 2.5% per year. If Henry is able to earn 12% a year in his account, how much should he deposit in the acount each year? (20 points total) Rate of Return Tuition Cost Year 0 Tuition Inflation Rate $ D $ 14,500.00 12.0% 14,500 2.5% Year 0 1 2 3 4 5 6 7 8 9 10. 11 12 Shawn's Age 9 10 11 12 13 14 15 16 17 18 19 20 21 $ $ $ $ $ 555 $ $ S ss. $ H $ Tuition 14,500.00 $ 14,862.50 15,234.06 15,614.91 16,005.29 16,405.42 16,815.55 17,235.94 17,666.84 18,108.51 18,561.23 19,025.26 19,500.89 Deposit Account Balance AB C PV of Total Tuition Annual Deposit Amount Q1 Henry Spencer is interested in saving money to put his son, Shawn, through college. Shawn is turning 9 years old today, and Henry wants to be able to deposit an equal amount into a savings account each birthday until Shawn turns 21. He wants the deposits to be just large enough to pay for all 4 years of Shawn's education, and he plans to make the first deposit in a year. You can assume that tuition payments will be made on Shawn's 18th through 21st birthdays. You can also assume that the current cost of tuition is $14,500 a year, and that the cost will increase by 2.5% per year. If Henry is able to earn 12% a year in his account, how much should he deposit in the acount each year? (20 points total) Rate of Return Tuition Cost Year 0 Tuition Inflation Rate $ D $ 14,500.00 12.0% 14,500 2.5% Year 0 1 2 3 4 5 6 7 8 9 10. 11 12 Shawn's Age 9 10 11 12 13 14 15 16 17 18 19 20 21 $ $ $ $ $ 555 $ $ S ss. $ H $ Tuition 14,500.00 $ 14,862.50 15,234.06 15,614.91 16,005.29 16,405.42 16,815.55 17,235.94 17,666.84 18,108.51 18,561.23 19,025.26 19,500.89 Deposit Account Balance
Expert Answer:
Answer rating: 100% (QA)
Solution using Excel Functions PV FV PMT Missing Information We cant directly calculate the annual deposit amount using only PV FV and PMT functions i... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Excel can be used to generate random integers between 0 and 9 inclusive. Suppose the following results are obtained. Use a 0.05 significance level to test the claim that the computer generates digits...
-
Describe how Excel can be used to calculate an allowance for uncollectible accounts using the percent of sales method.
-
Describe how Excel can be used to calculate an allowance for uncollectible accounts using the aging method.
-
Top executive officers of Preston Company, a merchandising firm, are preparing the next years budget. The controller has provided everyone with the current years projected income statement. Current...
-
Explain whether the bonds in these compounds would be ionic or covalent and show Lewis structures for them: (a) KC1 (b) NC13 (c) NaCN (d) KOH
-
The behavior of receptor X (XR), a transmembrane protein present in the plasma membrane of mammalian cells, is being investigated. The protein has been engineered as a fusion protein containing the...
-
Before the Asian currency crisis the Malaysian ringgit (RM) traded at about RM2.5000/S. In the initial months of the crisis the ringgit depreciated to above RM4.000/S. On September 1, 1998, 14 months...
-
What auction design features reduce the winners curse and therefore reduce strategic underbidding?
-
Built-Tight is preparing its master budget. Budgeted sales and cash payments follow: July August September Budgeted sales $ 56,000 $ 72,000 $ 56,000 Budgeted cash payments for Direct materials 15,560...
-
Julio buys a koi fishpond (and fish to put in it) for his wife on their anniversary. He pays $8000 for the pond and fish with $2000 down. The dealer charges add-on interest of 3.5% per year, and...
-
Mang Panday wants to determine the taxability of the foregoing. How much is the total amount of passive income which is subject to final tax?* 2 points Mang Panday, a resident citizen taxpayer...
-
You are required to analyse a listed company and make a investment recommendation report. The report provides an assessment of the company's current position and future prospects, incorporating the...
-
Question 1: Please transform the following E-R diagram to relations (20 points). (Note: Dep_Names means the dependent names for each Client.) E_Type DOB E_Phone E_ID Age Schedule EMPLOYEE "S"...
-
A 5 0 , 0 0 0 - pound truck is parked on a 1 0 you slope ( see figure ) . Assume the only force to overcome is that due to gravity. ( Round your answers to one decimal place. ) Weight = 5 0 , 0 0 0...
-
A. Organizational and managerial structures can create a synergy with Information System (IS) to create a unique sustained competitive advantage. With references to Porters Five Force model, state...
-
During the first quarter, Sheridan Company incurs the following direct labor costs: January $55,000, February $51,000, and March $64,500. For each month, indicate the amount of overhead assigned to...
-
Last year, Bad Tattoo Company had additions to retained earningsof $4,780 on sales of $95,560. The company had costs of $75,720,dividends of $2,980, and interest expense of $2,040. If the taxrate w 2...
-
Several months have passed and the Managing Partner approved and properly filed the Complaint and properly submitted the Request for Production of Documents that you drafted. In fact, it has been 75...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Indicate whether each of the items listed below would be included (I) in or excluded (E) from gross income for the 2012 tax year. ________a. Welfare payments ________b. Commissions ________c. Hobby...
-
Deborah purchases a new $30,000 car in 2012 to use exclusively in her business. If Deborah does not elect to expense or take bonus depreciation in 2012 and holds the car until it is fully...
-
Lomax Companys Statement No. 69 disclosures included the following information: REQUIRED: Using the information for Lomax Company in problems 13, 14, and 15 and in this problem: a. Compute the value...
-
Lomax Company reported the following expenses in its financial statements (in thousands): REQUIRED: Using the reserve disclosure for Lomax Company given in problem 13 and the data presented in this...
-
Discuss the ratios computed for Lomax Company in problems 13, 14, 15, and 16. What is your assessment of the performance and future potential of Lomax Company? Problems 13 The following reserve table...
Study smarter with the SolutionInn App