In an excel spreadsheet answer the scenarios below to, Ask an Expert

Finance

In an Excel spreadsheet answer the scenarios below. To submit this homework you must send the Excel sheet through e-mail as an attachment. The formulas and/or functions used must be in the excel sheet for me to review. Excel sheets with numbers only as answers will not be considered as submitted.

1) Calculate the interest rate earned in an investment that requires $759 to buy and pays back $1,000 in 3 years from now. The investment compounds quarterly.

2) Calculate how many years will it take for an investment to grow from $100,000 to $500,000 with a 20% APR that compounds monthly.

3) Calculate the future value of a 10% APR earning account in which you make $100 deposits every month for 3 years and you make your first deposit today.

4) Calculate the present value of an investment discounted at 8% and pays you $100 every 6 months for 5 years and you receive the first payment today. 5) Build an amortization table for a 12 month $2,500 loan. The loan has an 8% APR. Compounding and payments are monthly. The table should have the following headings:

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92708454

Have any Question?Write your Review or question?

Related Questions in Financial Management

This week will develop the theory and application of

This week will develop the theory and application of capital budget analysis. The theory was robust, the calculations mathematically and logically defined, and many of the real-world problems, likely to be encountered, w ...

Situationthe law affects the business environment and every

Situation The law affects the business environment and every single business and organization. These laws and regulations often come to light in current events as businesses find themselves represented in the press, eith ...

We have seen that there are 3 phases discussion making and

We have seen that there are 3 phases (Discussion; Making and accepting proposals; and closing the deal), in the process. Please respond in about 300 words. Do we need to follow them in sequence, or can we be flexible bet ...

Assignmentnow that you have gained an understanding of red

Assignment Now that you have gained an understanding of Red Carpet, Leroy has asked you to join in on a preliminary meeting with the VP of HR and other members of the organization to discuss change. The meeting was very ...

Question 1youre asked to assess whether your corporation

Question 1. You're asked to assess whether your corporation should invest in a long-term capital project. You calculate the payback period and NPV. Give an example of a specific recommendation you could make based on the ...

Assignment introduction to businessdirections be sure to

ASSIGNMENT : Introduction to Business Directions: Be sure to save an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure ...

Discussionbull profits and risks of off-balance-sheet

Discussion • Profits and Risks of Off-Balance-Sheet Activities • The difference between spot and forward exchange rates. What role do currency swaps play? • The Federal Open Market Committee • Multiple Deposit Creation a ...

Project risk finance and monitoring assignment -

Project risk, finance, and monitoring Assignment - Report Assessment Description - In this assessment in Part A students are asked to imagine they have been engaged by an external client to develop a report on key aspect ...

Using the framework discussed in the background readings

Using the framework discussed in the background readings, critically analyze General Mills' strategic choices at the Corporate level (remember that "corporate" level is the very highest level of the organization, with lo ...

Assignment -complete a research topic and prepare a

Assignment - Complete a research topic and prepare a write-up, and a presentation. SECTION A: Financial Analysis and Pricing Select a portfolio of five firms from the industry of your choice. Please then see me for appro ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Management Expert