Calculate approximate monthly amount to invest at the beginning of the period. Round the final answer...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Calculate approximate monthly amount to invest at the beginning of the period. Round the final answer to two decimals. Please note that intermediate steps should be calculated to at least 4 decimals to get the answer correctly. Assume the following information for your client Step 1 Child's AGE 2 Years to college Annual College Costs (current dollars) 3 4 Assumed College Inflation rate 5 College Inflation Factor. Calculate as (1+Step 4)^(Step 2) 6 Estimate Future Annual Costs Calculate as 7 Estimated Total Future Costs (Step 6) years in college 4 Funding requirements 8 Assumed after-tax return 9 PV Factor 10 Total Lump-Sum Investment Currently Required 11 Amount already earmarked for education 12 Additional Limp-Sum funding required 13 Years of funding 14 PVIFA Due 15 Annual target amount to invest 16 Approximate monthly amount to invest 3 18-(Step 1) $57,911 5.5% (1+Step 4)^(Step 2) (Step 3 Step 5) or use FV formula in Excel or financial calculator Step 6 years in college 10.7% 1/(1+Step 8)^Step 2 Step 7"Step 9 or use PV formula in Excel or financial calculator $27,116 Step 10-Step 11 5 Move to Step 15 to use Excel or financial calculator Step 12 Step 14) or use formula PMT in Excel or financial calculator Step 15)/12 months Calculate approximate monthly amount to invest at the beginning of the period. Round the final answer to two decimals. Please note that intermediate steps should be calculated to at least 4 decimals to get the answer correctly. Assume the following information for your client Step 1 Child's AGE 2 Years to college Annual College Costs (current dollars) 3 4 Assumed College Inflation rate 5 College Inflation Factor. Calculate as (1+Step 4)^(Step 2) 6 Estimate Future Annual Costs Calculate as 7 Estimated Total Future Costs (Step 6) years in college 4 Funding requirements 8 Assumed after-tax return 9 PV Factor 10 Total Lump-Sum Investment Currently Required 11 Amount already earmarked for education 12 Additional Limp-Sum funding required 13 Years of funding 14 PVIFA Due 15 Annual target amount to invest 16 Approximate monthly amount to invest 3 18-(Step 1) $57,911 5.5% (1+Step 4)^(Step 2) (Step 3 Step 5) or use FV formula in Excel or financial calculator Step 6 years in college 10.7% 1/(1+Step 8)^Step 2 Step 7"Step 9 or use PV formula in Excel or financial calculator $27,116 Step 10-Step 11 5 Move to Step 15 to use Excel or financial calculator Step 12 Step 14) or use formula PMT in Excel or financial calculator Step 15)/12 months
Expert Answer:
Answer rating: 100% (QA)
To answer this question we must follow the steps provided in the table Ill go through each step one by one 1 Childs AGE Given as 3 years 2 Years to co... View the full answer
Related Book For
Quantitative Methods for Business
ISBN: 978-0324651751
11th Edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam
Posted Date:
Students also viewed these accounting questions
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Calculate the approximate monthly amount to invest at the beginning of the period . Round the final answer to two decimals. Please note that intermediate steps should be calculated to at least 4...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Sketch the magnitude characteristic of the Bode plot for the transfer function -w'104 (jo + 1) ( jw + 10)(jw + 100)? G(jw)
-
Determine the reactions at \(A\) for the two-link mechanism of Figure P1.15. The roller at \(C\) rolls on a frictionless surface. A - 2 m B FIGURE P1.15 30 2.4 kg -3m 3.6 kg 2.6 m/s -1.4 m/s
-
Following is a sample of five matched pairs. Let 1 and 2 represent the population means and let d = 1 2. A test will be made of the hypotheses H0: d = 0 versus H1: d > 0. a. Compute the differences....
-
Safe Now sells its main product, ergonomic mouse pads, for $13 each. Its variable cost is $5.30 per pad. Fixed costs are $220,000 per month for volumes up to 65,000 pads. Above 65,000 pads, monthly...
-
Consider the following indifference curve graphs for five different applicants for a pay for performance job. Pay A B C D E Productivity/ Effort (Q) a. Define the marginal disutility of effort (also...
-
When you think of political persuasion, you may think of the effortsthat political campaigns undertake to persuade you that their candidate is betterthan the other candidate. In truth, campaigns are...
-
SECTION A Answer ALL the questions in this section. Study the statement of cash flows of Mantis Limited for the year ended 31 December 2021 and answer the following questions: 1.1Calculate the...
-
EI, an NFP with a calendar year end, had the following transactions involving contributions for Year 9: 1. EI received cash contributions of $500,000 to be used at the board of directors' discretion....
-
For Question 20, 21 and 22: please refer to Diagram 4 20. If Country A and Country B have the same indifference curves, who has the lower PS/PT in Autarky? a. Country A b. Country B c. Not enough...
-
The following statements relate to nongovernmental NFPs. Match the following terms with the statements indicated below: Fund accounting, variance power, program services, supporting services, FASB,...
-
Which is NOT a way team members and leaders help their teams achieve high performance?
-
Read "The 'ICE' Strategy" on Human Resource Management (pp. 89) of the PDF in Aetna: Investing In Diversity Case. Also review Exhibits 6 and 7 on pp. 2223 of the case study to see the link between...
-
The contribution margin ratio is: a. the same as the variable cost ratio b. the portion of equity contributed by the stockholders c. the same as profit d. the percentage of each dollar in sales that...
-
In Exercises 15 through 30, find the derivative dy/dx. In some of these problems, you may need to use implicit differentiation or logarithmic differentiation. y ex + et -2x 1 + e
-
J. D. Williams, Inc., is an investment advisory firm that manages more than $120 million in funds for its numerous clients. The company uses an asset allocation model that recommends the portion of...
-
A major traffic problem in the Greater Cincinnati area involves traffic attempting to cross the Ohio River from Cincinnati to Kentucky using Interstate 75. Let us assume that the probability of no...
-
Reep Construction recently won a contract for the excavation and site preparation of a new rest area on the Pennsylvania Turnpike. In preparing his bid for the job, Bob Reep, founder and president of...
-
Covenant Trucking Company uses the units-of-production (UOP) depreciation method because UOP best measures wear and tear on the trucks. Consider these facts about one Mack truck in the company's...
-
PepsiCo, Inc., has acquired several other companies. Assume that PepsiCo purchased Kettle Chips Co. for \(\$ 8\) million cash. The book value of Kettle Chips' assets is \(\$ 12\) million (market...
-
The board of directors of Park Place Porsche is having a quarterly meeting. Accounting policies are on the agenda, and depreciation is being discussed. A new board member, an attorney, has some...
Study smarter with the SolutionInn App