Question: Use the appropriate function in Excel to answer the following question. How much money would you have in a savings account at the end of

Use the appropriate function in Excel to answer the following question.

How much money would you have in a savings account at the end of 5 years if the following assumptions were true?

  • You make payments of $35 a month to your savings account every month for 5 years.
  • Your savings account has a fixed APR of 1.1%. Note: A fixed APR is an annual interest rate that does not change during the 5-year period.
  • You will not take any money out of your savings account during this 5-year period.
  • You have no beginning balance.(Round to the nearest cent)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To calculate the future value of the savings account at the end of 5 years with the given assumption... View full answer

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

Document Format (2 attachments)

PDF file Icon

66425585ad33b_982458.pdf

180 KBs PDF File

Word file Icon

66425585ad33b_982458.docx

120 KBs Word File

Students Have Also Explored These Related Finance Questions!

Q:

Use the appropriate function in Excel to answer the following question. How much money would you have in a savings account at the end of 3 years if the following assumptions were true? You make...

Q:

For each problem, show your work steps. A correct answer with no work shown gets half credit (which means you fail the assignment). An incorrect answer with no work receives 0 credit. With time value...

Q:

Describe how effectively Nedco's (https://www.nedco.ca/cnd/) omnichannel eCommerce strategy enables it to overcome its customers' demands as described in "Logistics Challenge #3: Fulfillment...

Q:

The function. t], describes the amount of money you would haye in a sayings account alter t years under the following assumptions: 1. Att = ll]. you initially haye 3501] in your sayings account. 2....

Q:

Question 9: (1 point) The Body Mass Index (BMI) is a number often used to determine if an individual has a healthy body mass. The function for finding an individual's BMI is: f(w,h)=720w h 2 What is...

Q:

Lesson 7 Homework Tiempo restante: Use the appropriate function in Excel to answer the following question. How much money would you have in a savings account at the end of 5 years if the following...

Q:

Use the appropriate function in Excel to answer the following question. How much money would you have in a savings account at the end of 4 years if the following assumptions were true? You make...

Q:

Use the appropriate function in Excel to answer the following question. How much money would you have in a savings account at the end of 3 years if the following assumptions were true? You make...

Q:

Use the appropriate function in Excel to answer the following question. How much money would you have in a savings account at the end of 3 years if the following assumptions were true? You make...

Q:

Use the appropriate function in Excel to answer the following question. How much money would you have in a savings account at the end of 4 years if the following assumptions were true? You make...

Q:

Tylers Consulting Company has purchased a new $15,000 copier. This overhead cost will be shared by the purchasing, accounting, and information technology departments since those are the only...

Q:

Olena Mirrors records bad debt using the allowance, income statement method. They recorded $343,160 in accounts receivable for the year and $577,930 in credit sales. The uncollectible percentage is...

Q:

1 July 2 0 1 4 , Leo Ltd purchased a machine at a price of $ 8 8 , 0 0 0 . The transport and installation costs amounted to 1 2 , 0 0 0 . The revaluation model was applied for the subsequent...

Q:

An RLC circuit such as that of Figure has R = 5.00, C = 20.0F, L = 1.00 H, and m = 30.0 V. (a) At what angular frequency w d will the current amplitude have its maximum value, as in the resonance...

Q:

What resistance R should be connected in series with an inductance L = 220 mH and capacitance C = 12.0F for the maximum charge on the capacitor to decay to 99.0% of its initial value in 50.0 cycles?...

Q:

Maximum surface resistance considers a square sheet of side L, thickness d, and electrical resistivity p. The resistance measured between opposite edges of the sheet is called the surface resistance:...

Q:

Zero point lattice displacement and strain (a) In the Debye approximation, show that the mean square displacement of an atom at absolute zero is R) = 3hw 2 D /8 2 pv 3 , where v is the velocity of...

Q:

It is well known that, although two materials are at the same temperature, one may feel cooler to the touch than the other. Consider thick plates of copper and glass, each at an initial temperature...

Q:

6 Theory of Machines 5. A shaft carries five masses A, B, C, D and E which revolve at the same radius in planes which are equidistant from one another. The magnitude of the masses in planes A, C and...

Q:

What are the three basic forms of business ownership? What are the advantages and disadvantages to each?

Q:

Given these two exchange rates, $1 = 0.9952 Australian dollars and $1 = 0.6476, compute the cross rate between the Australian dollars and the pound. State this exchange rate in Australian dollars and...

Q:

In 1997, many East Asian currencies suddenly and dramatically devalued. What is the percentage change in value of a $50 million investment in Indonesia when the exchange rate changes from $1 = 2,000...

Q:

Determine whether the product AB is defined, indicate what the dimensions of the product matrix will be, and find the product matrix, given The product AB is defined: the product matrix will be 2 2....

Q:

Redo Problem 5.15 for outlet 3 in Problem 5.3. Here Q = [29 36 24 32], P remains the same, and V=QP=29(400) +36 (300) + 24(250) + 32(500) = 44,400

Q:

If the price of a TV is $400, the price of a stereo is $300, the price of a VCR is $250, and the price of a camcorder is $500, use vector multiplication to find the value of stock for outlet 2 in...