o finance a vacation in 2 years, Elsie saves $380 at the beginning of every six months in an account paying intere t 13% compounded semi-annually. a) What will be the balance in her account when she takes the vacation? b) How much of the balance will be interest? c) If she waits an additional year to start her vacation, and continues to save the same amount of money, how muc more money does she have to spend?

o finance a vacation in 2 years, Elsie saves $380 at the beginning of every six months in an account paying intere t 13% compounded semi-annually. a) What will be the balance in her account when she takes the vacation? b) How much of the balance will be interest? c) If she waits an additional year to start her vacation, and continues to save the same amount of money, how muc more money does she have to spend?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 5E

See similar textbooks

Related questions

Q: Suppose James will have $25,000.00 for a down payment on a house in 6 years. How much would he have…

A: The question is based on the concept of future value calculation of an investment with a monthly…

Q: Jim has an annual income of $300,000. Jim is looking to buy a house with monthly property taxes of…

A: Here, To Find: Maximum monthly mortgage payment =?

Q: Ingrid wants to buy a $22,000 car in 7 years. How much money must she deposit at the end of each…

A: A sinking fund is a type of fund that is set up by an organization or company to accumulate money…

Q: Susan plans to make an investment today which promises to return to her $3,000 each year for ten…

A: Using excel PV function

Q: Katy has decided she wants to put money aside for a $8000 downpayment on a house. She figures she…

A: A theory that helps to compute the present or future value of the cash flows is term as the TVM…

Q: Mary decided to begin saving towards the purchase of a new car in 5 years. If Mary put $500 at the…

A: The future value is the amount that will be received at the end of a certain period. In simple…

Q: Abigail received a 15 year loan of $280,000 to purchase a house. The interest rate on the loan was…

A: Mortgage loans are paid by equal periodic and fixed payments and these carry the payment of interest…

Q: Mary wants to receive a payout of $1500 per month for 20 years. 1) How much money must be in the…

A: Using excel PMT and PV function

Q: Heather has $13,000 to put down on a new car priced at $25,000. The bank offers an annual interest…

A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…

Q: Mary Smith took a car loan of $20,000 to make 60 equal monthly payments. The interest compounds…

A: Annual worth distributes present worth into equivalent uniform value over its useful life.

Q: Mary would like to save at the end 5 years for a ire down payment on a car. a. How much should she…

A: A contract that allows one party to borrow funds, assets, or any other resource from the other is…

Q: Carol

A: The basic compound interest formula A = P(1 + r/n)nt .Priincipal is $1500,t= 25 years,r=3%.

Q: 1. Caroline wants to earn $500,000 at the end of eight years. How much must she deposit today to…

A: The question is based on the concept of annuities and future value in Financial Management.Annuities…

Q: What is her monthly payment amount? b) How much of the 8th payment would be applied toward…

A: The given problem can be solved with the help of some excel functions for finance. Here are the…

Q: A couple purchased their home for $280,000. They signed a 30 year mortgage at 5.28% interest…

A: Given: Cost of house = $280,000 Interest rate = 5.28% Period = 30 years Compounding monthly.

Q: give me answer in step by step

A: $759.21Explanation:We can calculate the amount michelle must deposit by using the future value…

Concept explainers

Cost of Credit

The cost of credit is an extra amount that the borrower has to pay besides the loan amount. These credit charges may vary from loan to loan. The cost of credit includes interest charges, maintenance charges, and arrangement charges. Some of the costs are mandatorily collected by the lender based on the loan amount and tenure of the loan. The cost of credit is also called finance charges of the credit.

Question

To finance a vacation in 2 years, Elsie saves $380 at the beginning of every six months in an account paying interest
at 13% compounded semi-annually.
(a) What will be the balance in her account when she takes the vacation?
(b) How much of the balance will be interest?
(c) If she waits an additional year to start her vacation, and continues to save the same amount of money, how much
more money does she have to spend?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Define=future value

VIEW

Step 2: Calculate future value

VIEW

Solution

VIEW

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

To finance a vacation in 4 years, Elsie saves $370 at the beginning of every six months in an account paying interest at 10% compounded semi-annually. (a) What will be the balance in her account when she takes the vacation? (b) How much of the balance will be interest? (c) If she waits an additional year to start her vacation, and continues to save the same amount of money, how much more money does she have to spend? a) The balance in her account will be s (Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as needed.) b) The amount of interest will be S. (Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as needed.) c) She will have an extra S to spend on her vacation. (Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as needed.)
Cinco
A person needs $17,700 immediately as a down payment on a new home. Suppose that she can borrow this money from her company credit union. She will be required to repay the loan in equal payments made every six months over the next 11 years. The annual interest rate being charged is 11% compounded continuously. What is the amount of each payment?
Mary wants to have $14000 for a trip to Mexico in five years. How much does she need to deposit at the end each month into an account earning 3.6% compounded monthly in order to have the money she needs?
Rebecca Carlson purchases a car for $25,000 and finances her purchase by borrowing the money at 8% per year compounded monthly; she pays off the loan with equal monthly payments for 5 years. What will be the size of her monthly loan payment?
Suppose Jennifer deposits $500 in an account at the end of this year. $400 at the end of the next year, and $300 at the end of the following year. If her opportunity cost rate is 7.5 percent, (a) how much will be in the account immediately after the third deposit is made? (b) How much will be in the account at the end of three years if the deposits are made at the beginning of each year?
Abigail received a 15 year loan of $280,000 to purchase a house. The interest rate on the loan was 5.80% compounded semi-annually. a. What is the size of the monthly loan payment? b. What is the balance of the loan at the end of year 2? c. By how much will the amortization period shorten if Abigail makes an extra payment of $30,000 at the end of year 2?
Ingrid wants to buy a $22,000 car in 6 years. How much money must she deposit at the end of each quarter in an account paying 5.8% compounded quarterly so that she will have enough to pay for her car? How much money must she deposit at the end of each quarter? $ (Round to the nearest cent as needed.)
Today, Tiffany is starting to save up for a downpayment on a house. Currently she has $635 in an account earning 8% semiannually. She will deposit $138 at the beginning of every two weeks for four years. After an additional six months (4.5 years from today), Tiffany pays the downpayment of $15,000 for her new home. What balance is remaining in this account?
The Fergusons want to purchase their first home and need $14,300 for a down payment. They can save $1,025 per quarter. If they deposit this amount in an account paying 3% interest compounded quarterly, how long will it be before they can purchase a home? (Solution should be entered in years accurate to the hundredths decimal place)
Jessica wants to accumulate $13,000 by the end of 6 years in a special bank account, which she had opened for this purpose. To achieve this goal, Jessica plans to deposit a fixed sum of money into the account at the end of the month over the 6-year period. If the bank pays interest at the rate of 5% per year compounded monthly, how much does she have to deposit each month into her account? (Round your answer to the nearest cent.)
Megan takes out a car loan for $13,000. She intends to make monthly payments for 5 years to pay off her loan. If the bank charges her an annual interest rate of 4.2% computed monthly on the loan balance, how much will her monthly payments be?