Question: what excel formula should i use to solve this problem? Your client has been accumulating money on college fund for years to be able to

what excel formula should i use to solve this problem? Your client has been accumulating money on college fund for years to be able to pay for his son's education. This year his son is accepted to college and he might continue his education after graduation. Leaving aside issues of inflation and annual increase in the cost of tuition and fees, the funds would last 7 years with equal semi-annual beginning-of-the-period payments of $35,236 each, with the first payment to be made today. If the annual interest rate is 14.49 percent compounded semi-annually, how much has your client accumulated on college fund? (You need to calculate present value of college payments)

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!

Hello! Please I need the full answers. Because I need to use the formulas when I answer. . xcel McGraw Hill Excel Question - Saved Search (Alt + Q) File Home Insert Draw Formulas Data Review View ...

Question 5 4 pts On January 1, 2017, we purchased a truck for $55,000. The truck has a useful life of 5 years or 100,000 miles and a residual value of $5,000. The actual mileage for the truck was...

what formula do i use to solve this problem? Your client has been accumulating money on college fund for years to be able to pay for his son's education. This year his son is accepted to college and...

William's son starts college in 12 years. He estimates the current deficit for his college education funds is $54,321. Assume that after-tax rate of return that William is able to earn from his...

1.For each problem, say which formula you would use to solve the problem (simple interest, compound interest, annuity, payout annuity/loan) and which variable you would be trying to find. Explain why...

For each problem, say which formula you would use to solve the problem (simple interest, compound interest, annuity, payout annuity/loan) and which variable you would be trying to find. Explain why...

Mary's son will be attending college in 6 years. Assume current tuition and fees are $52,779, and inflation for college costs averages 7.6 percent. Mary can earn 4.8 percent on the money she invests...

I need the answers or instructions on how to get the answers for all of problem three and the unfinished part of problem 4. This class is financial modeling, must use the formulas by tagging them to...

How many years will the following take? $539 to grow to $33,319 if invested at 9.60 percent, compounded annually. Answer Round the answer to two decimal places. Your client plans to buy a house in 6...

Your client plans to buy a house in 6 years. He wants to save money for a down payment on the new house. He are able to place $156 every month at the end of the month into a savings account at an...

Jenny has a quadratic utility function of the form U(w) w-10 w. She has been offered a job with Company X, in which her salary would depend upon the success or otherwise of the company. If it is...

1.15 A sandstone core sample (d=1.90 cm and L=3.20 cm) is satu- rated with a brine of 0.55-0 m resistivity. The core was desaturated in steps, and the following resistances were meas- ured at each...

Rickhard's sales are recorded in TipTop's ERP system, which is not integrated with TipTop's standalone CRM . By definition, a CRM system does not track customer interactions after a lead becomes a...

In January 2007, the Status Quo Company was formed. Total assets were $544,000, of which $306,000 consisted of depreciable fixed assets. Status Quo uses straight-line depreciation of $30,600 per...

Bourdon Software has 6.4 percent coupon bonds on the market with 18 years to maturity. The bonds make semiannual payments and currently sell for 106.8 percent of par. What is the current yield on the...

(a) Accounting plays a relatively unimportant role in budgeting. Do you agree? Explain. (b) What responsibilities does management have in budgeting?

In preparing the direct materials budget for Quan Company, management concludes that required purchases are 64,000 units. If 52,000 direct materials units are required in production and there are...

The East Division of Kensic Company manufactures a vital component that is used in one of Kensics major product lines. The East Division has been experiencing some difficulty in coordinating...

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...

17-2. What are some of the specific, uniquely international activities an international HR manager typically engages in?

17-8. Choose three traits useful for selecting international assignees, and create a straightforward test to screen candidates for these traits.

17-9. Use a library or Internet source to determine the relative cost of living in five countries as of this year, and explain the implications of such differences for drafting a pay plan for...