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...
-
A 0.9-kg block B is connected by a cord to a 2.4-kg block A which is suspended as shown from two springs, each of constant k = 180 N/m, and a dashpot of damping coefficient c = 60N ?? s/m. Knowing...
-
On May 1, 2008, a two-year insurance policy was purchased for \($24,000\) with coverage to begin immediately. What is the amount of insurance expense that appears on the companys income statement for...
-
Sony ('orp). launched its PlayStation 4 in late 2013. It was introduced at a price point of \(\$ 399\). At the time of introduction, a technology firm performed a tear-down of the PlayStation and...
-
Lucie likes consuming candy (c) and fruit (f), and dislikes consuming plastic packaging (p), and has rational preferences over bundles (c, f, p). No matter how many units of each good she has, Lucie...
-
The standard auditors' report refers to standards of the PCAOB and GAAP in which section(s)? a. Standards of the PCAOB: Opinion on the Financial Statements; GAAP: Opinion on the Financial Statements...
-
1. Using the spreadsheet model from Case 2.1 as a starting point, use Solver to find the optimal set of projects to approve. The solution should maximize the total NPV from the approved projects, and...
-
Define staining techniques? And also explain its classifications .
-
3) A payment method where the nominated bank will give the beneficiary an irrevocable deferred payment undertaking" to the effect the bank will pay on a certain future date? Who will be the drawee of...
-
How many units of item J are required to make 63 units of item E? E B(2) J(4) F(2) J(3)
-
The standard cost of Product B manufactured by Oriole Company includes 3.8 units of direct materials at $6.30 per unit. During June, 27,000 units of direct materials are purchased at a cost of $6.20...
-
Explain with the help of case study for GOOD SERVICE TAX.
-
Consider the sample regression equation: y=12+3x 1 -5x 2 +7x 3 -2x 4 .When x 1 increases by 1 unit and x 2 increases by 2 units, while x 3 and x 4 remain unchanged, what change would you expect in...
-
Georgette Johnson is the revenue manager at the 700-room Doubletree hotel in Orlando. She also heads her property's Revenue Management committee. Georgette is preparing for the hotel executive...
-
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...
-
Determine the average age of accounts payable and payable turns for the commercial construction company. Use only the material and subcontract construction costs to calculate the average of accounts...
-
Determine the assets to revenues ratio for the commercial construction company. What insight does this give you into the companys financial operations?
-
Determine the collection periodwith and without retentionand receivable turns for the commercial construction company. What insight does this give you into the companys financial operations?
Study smarter with the SolutionInn App