Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

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.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M918391

Have any Question? 


Related Questions in Basic Finance

Change your cover letter to an email messagechange a cover

Change your cover letter to an email message. Change a cover letter you wrote previously (or the one you wrote for Exercise 4) to a version you'll send as an email. What changes will you make in the salutation and format ...

1 disadvantage of high liquidity what is a disadvantage of

1. Disadvantage of High Liquidity. What is a disadvantage of maintaining a very high level of liquidity? 2. Economic Impact on Liquidity Needs. Assume that your monthly expenses will not change over the next three years, ...

After reading concept four write a 2-4 page paper

After reading Concept Four, write a 2-4 page paper discussing the issues and outcomes of Alpha Health Systems (AHS), giving a brief overview of its initial implementation of a corporate finance-based capital allocation p ...

1 what is the role of finance in a strategic plan2 what are

1) What is the role of finance in a strategic plan? 2) What are operating and financial plans? Please elaborate

Does the estimated maximum preload threaten your boltsyou

Does the estimated maximum preload threaten your bolts? You guess, since this is a conventional or typical joint, that the joint to bolt stiffness ratio is 5:1. You believe that the tensile loads applied to this joint in ...

Suppose that you wish to buy stock and protect yourself

Suppose that you wish to buy stock and protect yourself against a downside movement in its price. You consider both a covered call and a protective put. What factors will affect your decision? You have inherited some sto ...

Evaluate the expression uwxyz exactly as parenthesized ie

Evaluate the expression (u+)+(w+x)+(y+z) exactly as parenthesized (i.e., do not use the commutative or associative laws to reorder the additions). Give register-level machine code to provide the maximum possible parallel ...

Shelton inc has sales of 393000 costs of 181000

Shelton, Inc., has sales of $393,000, costs of $181,000, depreciation expense of $46,000, interest expense of $27,000, and a tax rate of 30 percent. (Do not round intermediate calculations.) What is the net income for th ...

1 would you expect the profit margin in a quality jewelry

1. Would you expect the profit margin in a quality jewelry store to differ from that of a grocery store? Comment. 2. The ratio return on assets has net income in the numerator and total assets in the denominator. Explain ...

Consider an option on a non-dividend paying stock whose

Consider an option on a non-dividend paying stock whose share price is sh 120. The exercise price is sh 130, risk free rate is 10% per annum, volatility is 20% per annum and the time to maturity is one year. Construct a ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro