Would they be able to take the vacation

Assignment Help Financial Management

Reference no: EM131983756

Selma and Troy are planning to take a second honeymoon in two years. They estimate that the cost will be roughly $7,985.74.

They plan to make monthly payments of $275 and expect to receive 10% annual interest on their savings.

Given this information:

a) Would they be able to take the vacation (what is the exact amount over or under their goal)?

b) What must the annual interest rate be in order to make their goal exactly?

c) What must their monthly savings payments be in order to reach their goal if the annual interest rate drops 4.5% below the rate found in part b of this problem?

You have to enter the info into a spreadsheet like this:

Relevant Information
Annual Interest Rate
Periods Per Year
Number of Years

Needed Information
Present Value					PV
Future Value					FV
Payment					PMT
Rate					RATE
Number of Periods					NPER

Additional Calculations (if needed)




Answer:

Reference no: EM131983756

Questions Cloud

Analyze the ipo by investigating the stocks issue price : Analyze the IPO by investigating the stock's issue price, number of shares, and increase in equity for the company.

Create project management plan that everybody : What actions are necessary to create Project Management Plan that everybody can approve?

Compute the portfolio beta : Select a portfolio of common stocks in five companies whose stock is traded on the New York Stock Exchange (NYSE).

Compose a thousand word essay on learning organisations : Compose a thousand word essay on learning organisations. Explain what a learning culture entails, what a learning organisation is

Would they be able to take the vacation : Selma and Troy are planning to take a second honeymoon in two years. They estimate that the cost will be roughly $7,985.74.

Individual differences in person perception : In our reading assignment this week, Individual Differences in Person Perception, we learn about how our individual perceptions influence the way we see

What fraction of the firm will the vc receive in exchange : What fraction of the firm will the VC receive in exchange for its $2.5 million investment in your company? Round your answer to two decimal places.

What amount of depreciation will laguna madre record : Refer to SuperByte Corporation. What amount of depreciation will Laguna Madre record in its income statement on December 31 of the current year?

How much money do you receive from the buyer : The current bid and ask quotes are $27.33 and $27.36, respectively. You place a limit sell-order at $27.35.

User Account

All Pages