Question: please solve this question on excel Olivia wants to have $5000 to upgrade ter VW bus in 4 years How much must she deposit now

please solve this question on excel Olivia wants to have $5000

please solve this question on excel

Olivia wants to have $5000 to upgrade ter VW bus in 4 years How much must she deposit now in a savings account that pays 6 percent annually, compounded monthly, to have the morny she needs in 4 years Answer in the following format Round to the nearest cent 20.00 . Do not round intermediary calculations Use full precision of your calculator or excel Do not include a sign . Do not include commas Round properly to two decimal places - Example 3.157835 would be 3.16 IMPORTANT NOTE YOU MUST ANSWER THIS QUESTION BEFORE MOVING ONWARD. YOU CANNOT RETURN TO THIS QUESTION IF YOU MOVE FORWARD IN THE GOU Atiswer Next page

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Income Statement, Statement of Owner's Equity, and Balance Sheet Paulson's Pet Store completed the Adjusted Trial Balance for the year ended December 31, 20--. Owner's equity as of January 1, 20--,...

Olivia wants to have $5000 to upgrade her VW bus in 3 years. How much must she deposit now in a savings account that pays 15 percent annually, compounded monthly, to have the money she needs in 3...

Olivia wants to have $5000 to upgrade her VW bus in 2 years. How much must she deposit now in a savings account that pays 18 percent compounded monthly to have the money she needs in 2 years?

Please solve these problems in Excel 1. Jose has $20,000 invested in a mutual fund that yields 8% return a year. How much money will Jose has in 20 years? 2. A bank promises daily compounding of...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Dr.Ramsey Please assist me with my discussion post. Subject: Annuities Systematic risk evaluates the probability and extent of negative consequences to the larger body. For example, the government...

this is all the information required to do assignment Personal Financial Planning Mini-Case Jeff and Mary Douglas, a couple in their mid-30s, have two children - Paul age 6 and Marcy age 7. The...

Can anyone solve the answers from the given document givenbelow? I really need help. MY FINAL LITERALLY IS KNOCKING AT THE DOOR. Name_________________________________ Student...

1. A bank is paying interest at a 5% annual rate on deposits. If you invest 10,000 and the bank compounds interest daily (i.e., 365 times per year), which of the following shows how much you will...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

1. An asset having an eight-year service life and a salvage value of $14,000 was acquired for $142,000 cash on April 5. Using straight-line depreciation, what will be the depreciation expense at the...

Find all values of p for which the following integral (a) converges and (b) diverges cos (x) dx L1+x*)p"

The cost in dollars of producing x units of a certain commodity is given below. C ( x ) = 9 0 0 0 + 1 6 x + 0 . 3 x 2 ( Round your answers to within the nearest cent if necessary, but do not round...

Assume that you will be conducting a meeting to resolve the issues in the scenario below. Imagine you are the regional manager. You will need to prepare a coaching session You will need to fill in...

A water sample was analyzed and was found to have the following constituents: Ca", mg/L HCO,, mg/L 82 so,, mg/L 122 112 123 Mg, mg/L 22.1 12 Na', mg/L K', mg/L Fe", mg/L Mn", mg/L 1.5 Cr, mg/L Co,...

Jessica Ltd sold inventory during the current period to its wholly-owned subsidiary, Amelie Ltd, for $15,000. These items previously cost Jessica Ltd $12,000. Amelie Ltd subsequently sold half the...

State 5 shipboard systems

Ken Blanchard, John Carlos, and Alan Randolph wrote Empowerment Takes More Than a Minute (1998) to give working tools to people who want to be empowering leaders. The book is organized in story form,...

To what extent should leadership be assigned to a single group member?

How do todays organizations diff er from those of earlier eras?