Question: Please answer with an excel formula Assume the total cost of a college education will be ( $ 325,000 ) when your child enters college

Please answer with an excel formula Assume the total cost of a college education will be $ \$ 325,000 $ when your child enters college in 18 years. You presently have $ \$ 85,000 $ to invest. What annual rate of interest must you ea 2 answers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Solve the following problems and upload the Excel File. Assume the total cost of a college education will be $ 3 4 5 , 0 0 0 when your child enters college in 1 8 years. You presently have $ 7 3 , 0...

please give answer in anExcel formula Assume the total cost of a college education will be $ \$ 325,000 $ when your child enters college in 18 years. You presently have $ \$ 85,000 $ to invest....

Please answer both questions 1. Assume that the total cost of a college education will be $345,000 when your child enters college in 18 years. You presently have $73,000 to invest. What annual rate...

Using excel formulas!!!!!! Assume the total cost of a college education will be $325,000 when your child enters college in 18 years. You presently have $85,000 to invest. What annual rate of interest...

needs to be in excel format Assume the total cost of a college education will be $320,000 when your child enters college in 18 years. You presently have $67,000 to invest. What annual rate of...

What is the formula? Assume the total cost of a college education will be $ \$ 325,000 $ when your child enters college in 18 years. You presently have $ \$ 85,000 $ to invest. What annual rate...

Question 11 [5 pts] Prudential Mutual has an unfunded pension liability of $450 million that must be paid in 20 years. To assess the value of the firms stock, financial analysts want to take into...

Assume the total cost of a college education will be $395,000 when your child enters college in 18 years. You presently have $65,000 to invest. What annual rate of interest must you earn on your...

Assume the total cost of a college education will be $200,000 when your child enters college in 16 years. You presently have $70,000 to invest. What annual rate of interest must you earn on your...

PAR T 3 Valuation of Future Cash Flows 1 0 . 0 4 % 6 . 8 . 0 4 years 7 . 1 6 . 0 9 years 3 . 7 5 % 8 . 2 4 . 0 5 years 9 . $ 1 3 6 , 9 3 1 , 4 7 1 . 8 5 1 0 . $ 1 , 0 1 3 . 6 3 1 1 . $ 4 , 4 5 4 . 8...

Air at 170 kPa and 80C flows upward through a 10-cm-diameter inclined duct at a rate of 55 L/s. The duct diameter is then reduced to 6 cm through a reducer. AP across the reducer is measured by a...

Question 3 Hegemony is defined as: 0.2 pts operating when the goals, ideas, and interests of the working class are normalized and institutionalized. ensures power is shared equally by all members of...

Evaluate the integral. \ int _ 1 ^ 4 5 ( ( x - 1 ) ^ ( 3 ) ) / ( x ^ ( 2 ) ) dx

A 3.5 kg block is pushed along a horizontal floor by a force F of magnitude 15 N at an angle = 40 o with the horizontal (Figure). The coefficient of kinetic friction between the block and the floor...

The 2014 comparative income statement and the 2014 comparative balance sheet of Golf America, Inc., have just been distributed at a meeting of the companys board of directors. The members of the...

( GAAP Terminology) Wayne Rogers, an administrator at a major university, recently said, Ive got some CDs in my IRA, which I set up to beat the IRS. As elsewhere, in the world of accounting and...

Change in Estimate and Error; Financial Statements Presented below are the comparative income statements for Pannebecker Inc. for the years 2009 and 2010. The following additional information is...

Valley Mills Construction, Inc., had the following stockholders equity on June 30, 2013: Common stock, no-par, 100,000 shares issued ......... $250,000 Retained...

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

To the closest year, how long will it take $200 to double if it is deposited and earns the following rates? [Notes: (1) See the hint for Problem 2-1. (2) This problem cannot be solved exactly with...

Differentiate among the expected rate of return (r), the required rate of return (r), and the realized, after-the-fact return (r-) on a stock. Which would have to be larger to get you to buy the...

What does the R2 measure? What is the R2 for a typical company?