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 define external validity and indicate its importance to

1. Define external validity, and indicate its importance to scientific progress. 2. Why is it never possible to know whether a research finding will generalize to all populations of individuals? How do behavioral scienti ...

What primary factors determine the number of load cycles

What primary factors determine the number of load cycles required to break a bolt subject to fatigue loading? Describe the appearance of the break surface of a bolt which has failed in fatigue ? Where on a bolt are you m ...

Question 1is there a way to determine which type of project

Question 1 Is there a way to determine which type of project (profitable or unprofitable) we have, without waiting until the actual results for comparison? Write in 150 words withREFERENCES. Question 2 What if one uses t ...

Contrast lookback options and barrier options and explain

Contrast lookback options and barrier options and explain the difference between in- and out-options ? Explain how weather derivatives could be used by an electric utility to manage the risk associated with power consump ...

An investor can make an investment in a real estate

An investor can make an investment in a real estate development and receive an expected cash return of $45,000 at the end of six years. Based on a careful study of other investment alternatives, she believes that a 9 per ...

The cash conversion cycle is an important tool for the

The cash conversion cycle is an important tool for the financial manager in managing day-to-day operations of the firm. As an investor, knowing how the firm manages its CCC would provide useful insights about management' ...

Bellamee company has bonds outstanding with five years to

Bellamee Company has bonds outstanding with five years to maturity and a face value of $5,299. The bonds are currently priced at their face value. If the bonds have a coupon rate of 25 percent, then what is Bellamee's af ...

Normas cat food of shell knob ships cat food throughout the

Norma's Cat Food of Shell Knob ships cat food throughout the country. Norma has determined that through the establishment of local collection centers around the country, she can speed up the collection of payments by two ...

What is the accounting identity list at least three of the

What is the accounting identity? List at least three of the assumptions underlying financial statements? Identify at least three current asset accounts ? What is the operating cycle ? Identify three current liability acc ...

1 selecting a bank steve just received his first paycheck

1. Selecting a Bank. Steve just received his first paycheck and wants to open a checking account. There are five banks in his hometown. What factors should Steve consider when choosing a bank? 2. Influence of Interest Ra ...

  • 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