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

Financediscussion 1multinational financial management

Finance Discussion 1 "Multinational Financial Management" Please respond to the following: • From the e-Activity, determine key reasons why a multinational corporation might decide to borrow in a country such as Brazil, ...

Consider a 75000 30-year fixed-rate mortgage with 775

Consider a $75,000, 30-year, fixed-rate mortgage with 7.75 percent interest and monthly payments. The lender requires that the borrower pay two points to originate the loan. a) If the expected holding period is 30 years, ...

Financial crisis discussion postwhat were some of the

Financial Crisis Discussion Post What were some of the credit risks that arose from the 2008 financial crisis? How were banks affected by the credit risks? How were individuals and businesses affected by the credit risks ...

Speculate as to why there has been an increase in reporting

Speculate as to why there has been an increase in reporting requirements in the last ten (10) years. Also, give your opinion on whether the increase in reporting requirements has improved investors' and creditors' confid ...

Question 1 - wing onn tong pte ltd is a private company

Question 1 - Wing Onn Tong Pte Ltd is a private company limited by shares incorporated in Singapore. It is in the business of selling traditional Chinese medicine (TCM). The company's object is "to sell traditional Chine ...

Rtio analysisextraordinary items and ratio analysis

Ratio Analysis "Extraordinary Items and Ratio Analysis" Please respond to the following: • Choose at least two items or events that you would consider to be extraordinary to a company. Propose the manner in which you wou ...

Surplus and deficit units explain the meaning of surplus

Surplus and Deficit Units Explain the meaning of surplus units and deficit units. Provide an example of each. Which types of financial institutions do you deal with? Explain whether you are acting as a surplus unit or a ...

In what form can a depository institution hold reserveswho

In what form can a depository institution hold reserves? Who determines the amount of funds available for reserves? How does the Fed infl uence the amount of reserves a depository institution must hold?

Finance assignment- part 1 group written assignmenttask

Finance Assignment- Part 1: Group Written Assignment Task Description - As part of this assessment you are required to conduct your own research of market and financial data online. 1. Evidence of Group Work Please see t ...

The growth in global sourcing and supply often

The growth in global sourcing and supply often levels  the playing field for adding worldwide value. Companies need at least to  consider, if not implement, global value chains as their predominant mode of  business. The ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate