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

1 suppose you withdraw 1000 from your checking account and

1. Suppose you withdraw $1,000 from your checking account and use the funds to buy a certificate of deposit at your bank. How will these actions affect M1 and M2? Why aren't credit cards included in M1 or M2? 2. In a rep ...

Corporation y needs to purchase a new machine costing 208

Corporation Y needs to purchase a new machine costing $2.08 million. Management is estimating the machine will generate cash inflows of $396,000 for two years and $300,000 for the following seven years. If management req ...

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

Design a randomized groups experiment to test the

Design a randomized groups experiment to test the hypothesis that children who watch an hour-long violent television show subsequently play in a more aggressive fashion than children who watch a nonviolent TV show or who ...

Q1 what is the market value of the following bondcoupon

Q1. What is the market value of the following bond? Coupon 8% Maturity date 2038 Interest paid semiannually Par Value $1000 Market interest rate 10% Q2. What is the market value of the following bond? Coupon 9% Maturity ...

1 according to readygov what are the three basic steps

1. According to Ready.Gov, what are the three basic steps people can take to prepare for any type of disaster? 2. What are the seven key elements that can be used to measure the comprehensive nature of an evacuation plan ...

If a company is deciding between two projects and can only

If a company is deciding between two projects, and can only select one of the two projects, what evaluation techniques should this company use in the analysis of these projects? When selecting capital projects and there ...

Do you think education would be better if it were

Do you think education would be better if it were privatized in the United States? What are the benefits of education being privatized? What are the drawbacks? What are the benefits of public education? What are the draw ...

Dr jones conducts an experiment investigating the effects

Dr. Jones conducts an experiment investigating the effects of distraction on memory. A list of 40 two-syllable words is prepared. Dr. Jones obtains a sample of 50 students, all between the ages of 18 and 22, and presents ...

1 how have individual states become more active monitors of

1. How have individual states become more active monitors of takeover activity? 2. What is the signaling theory of mergers? What is the relationship between signaling and the mode of payment used in acquisitions? Is ther ...

  • 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