Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. using excel functions 1.bob fry wants to buy his

using excel functions 1.Bob Fry wants to buy his grandson a Ford Taurus in...

80.2K

Verified Solution

Question

Finance

using excel functions

1.Bob Fry wants to buy his grandson a Ford Taurus in 4 years. The cost of a car will be

$28,000. Assuming a bank rate of 4% compounded quarterly, how much must Bob put in the bank today?

2.Bill Blum needs $40,000 6 years from today to attend V.P.R. Tech. How much must Bill put in the bank today (8% quarterly) to reach his goal?

3.

Column1 FV Time Rate Table Period Rate Used PV Factor PV amount
question 1 $9,000 7 years 2.5% semi annual
question 2 $20,000 20 years 4% annually

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Question 1 Assume Alpha Ltd is currently trading on the NYSE with a stock price of $65....

Finance
Q

The company has a new process for manufacturing large artificial sapphires. In a trial run, 12...

Statistics
Q

Consider the following real 3rd order polynomial f (x)= x^3− 5.5 x^2− 5x+ 37.5 A) Use the...

Advance Math
Q

what is a gene chip? ehat are ethical considerations of having our genetic information \"out there\"...

Biology
Q

A paddlewheel is made by attaching 4 thin uniform blades of length L and massmo to...

Physics
Q

2 Calculate the potential energy kinetic energy mechanical energy velocity and height of the ball...

Physics
Q

A 17 m Using trapezoids estimate the total distance the runner travels from t 0...

Calculus
Q

Why do states control Medicaid expenditures through low reimbursement rates instead of using cost sharing?...

Accounting
Q

Provided are links to the present and future value tables: (PV of $1, FV of...

Accounting
Q

referring to a form 941, if line 3=$14,000.00 and column 1 of both lines 5a...

Accounting
Q

QUESTION 20 Dividing the current price of the stock by its earnings per share would...

Finance
Q

a. Julie paid $2,060 to the day care center and her AGI is $50,600 (all...

Accounting