Make a worksheet to show saving for paying for your childs, Ask an Expert

Finance

problem: Make a worksheet to show saving for paying for your child's college tuition in ten years. The full tuition is dollars 100,000. Make a data table that shows the FV of the monthly savings and the percentage of the dollar 100,000 saved so far with monthly payments from dollar 250 to dollar 800 in dollar 50 increments.

Tuition = $100,000 [name this cell and use in formula]

Savings Interest Rate = 7.25% [Clue *12 for monthly]

Period = 10 years [Hint * 12 months]

Payment Pmt = $300

Percentage of Tuition saved = FV/tuition

Apply goal seek to determine the exact amount to save each month to have the full tuition.

Use conditional formatting to highlight when the savings is equal to and greater than $100,000 in the data table.

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M918391

Have any Question?Write your Review or question?

Related Questions in Basic Finance

You observe following exchange rate quotations 1 is equal

You observe following exchange rate quotations: $1 is equal to 6.4568 Chinese yuan 1 Japanese yen equal to 0.0616 Chinese yuan. How many U.S. dollars will you need to purchase 1 billion Japanese yen?

Obnk has a plowback rate of 30 a roe of 20 and a

OBNK has a plowback rate of 30%, a ROE of 20%, and a capitalization rate of 10% p.a. In three years OBNK is expected to increase its plowback rate to 40% and its ROE is expected to decrease to 10%. What is the intrinsic ...

Your are the investment advisor for your aunt who would

Your are the investment advisor for your aunt who would like to invest $1,250,000 with a AAA rated insurance company that will pay her a "monthly" fixed-payment annuity for the next 20-years. Calculate the monthly paymen ...

Supposenbspintels stock has an expected return of 220 and a

Suppose? Intel's stock has an expected return of 22.0% and a volatility of 23.0%?, while? Coca-Cola's has an expected return of 8.0% and volatility of 15.0%. If these two stocks were perfectly negatively correlated?(i.e. ...

If the rate of inflation is 43 what nominal interest rate

If the rate of inflation is 4.3%?, what nominal interest rate is necessary for you to earn a 2.8% real interest rate on your? investment? ?(Note: Be careful not to round any intermediate steps less than six decimal? plac ...

Suppose that a 2-year bond has a face value of 1000 and

Suppose that a 2-year bond has a face value of 1000 and pays semi-annual coupons of 50. If the price is 930, compute YTM and EAY.

Grant technologies needs 300000 to pay its supplier grants

Grant Technologies needs $300,000 to pay its supplier. Grant's bank is offering a 210-day simple interest loan with a quoted interest rate of 11 percent and a 20 percent compensating balance requirement. Assuming there a ...

Assignment - financial statement disclosuresone of the

Assignment - Financial statement disclosures One of the projects that the International Accounting Standards Board (IASB) is currently undertaking is the Disclosure Initiative project, with the aim of improving communica ...

Forecasting problem -double exponential smoothing using the

FORECASTING Problem - Double Exponential Smoothing: Using the Durable Marbles Inc. - a company with corporate head office in Europe, table data given below, compute the exponential smoothing with smoothing coefficients o ...

A 1000 par value bond was issued 15 years ago at a 12

A $1,000 par value bond was issued 15 years ago at a 12 percent coupon rate. It currently has 15 years remaining to maturity. Interest rates on similar obligations are now 8 percent. Assume Ms. Bright bought the bond thr ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert