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

A piece of newly purchased industrial equipment costs

A piece of newly purchased industrial equipment costs $960,000 and is classified as seven-year property under MACRS. Calculate the annual depreciation allowances and the end-of-year book values for this.

Beverages is negotiating a lease on a new piece of

Beverages is negotiating a lease on a new piece of equipment that would cost $100,000 if purchased. The equipment falls into the MACRS 3-year class, and it would be used for 3 years and then sold, because the firm plans ...

1 list four important drivers of housing demand and price

1. List four important drivers of housing demand and price appreciation. 2. What are public goods? How may they be reflected in house prices? 3. When considering an investment in "distressed'' properties, what are the tw ...

1 discuss the pros and cons of using naturalistic versus

1. Discuss the pros and cons of using naturalistic versus contrived observation. 2. What special opportunities and problems does participant observation create for researchers? 3. What does it mean if a behavior is react ...

1 why does the inverse relationship between the inflation

1. Why does the inverse relationship between the inflation rate and the unemployment rate on the Phillips curve hold only in the short run? In the long run, what happens when the actual inflation rate differs from the ex ...

Company b just paid an annual dividend of 42 a share the

Company B just paid an annual dividend of $.42 a share. The stock is selling for $18 a share and has a growth rate of 2.2 percent. What is the dividend yield, using the constant growth model?

1 in what ways is the study of research methods valuable to

1. In what ways is the study of research methods valuable to students such as you? 2. Discuss the importance of systematic empiricism, public verification, and solvability to the scientific method. In what ways does pseu ...

A recent survey at a major corporation found that employees

A recent survey at a major corporation found that employees who regularly participated in the company fitness program tended to have fewer sick days than employees who did not participate. However, because the study was ...

Go to the library and find a research article in a

Go to the library and find a research article in a psychology journal that used analysis of variance. (This should not be difficult; ANOVA is perhaps the most commonly used analysis. If you have problems, try the journal ...

Analyze the capital asset pricing model capmbull explain

Analyze the Capital Asset Pricing Model (CAPM). • Explain how the CAPM assists in measuring both risk and return. • Explain how the CAPM assists in calculating the weighted average costs of capital (WACC) and its compone ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen