Question: Hello, I really need help with the following 5 questions: 1.At what annual rate of return can you triple your money in8years if interest is

Hello,

I really need help with the following 5 questions:

1.At what annual rate of return can you triple your money in8years if interest is compounded monthly?

2.At what annualrate of return can you quadruple(means4times)your money in16 years,if interest is compounded quarterly?

3.How many periods will it take you to quadruple(means4times)your money at7%,if interest is compounded semi-annually?how many years will it take?

4.What is the present value of$15,500received in10years if interest of1%is compounded monthly?

5.What is the present value of$22,000received in5years if interest of1%is compounded quarterly?

I need the answer to be provided in excel because I need to know how to do the rest of my problems myself. I need to know if formula FX , PV or RATE was used and the answer must be broken down using excel as below:

NPER

RATE

PMT

Thanks so much.

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!

If the Brodys took the American Opportunity Tax Credit (AOTC), and Julia also had income of $51,000, what would be the nonrefundable portion of that credit? $0 $180 $271 $1,500

My student number is: 1 2 3 - 4 5 - 6 7 8 9 Provide your response for the following problems:Using Excel FunctionUsing Excel as CalculatorText Response 1 A financial analyst tells you that investing...

So we were given a practice case to assist us in preparing us for the exam. I tried solving it, but was not sure if the answers are correct. Is anyone able to answer each component step by step of...

Hello! I really need help with the following exercise.... I have attached 2 documents. 1 with the instruction and another with charts that need to be filled out. Please let me know if you can help!...

Need help with these discussion postings (in a document) and assignments (all in separate files), all directions are included as well. FINANCE DIRECTIONS Need to provide 1 original post substantial...

Hello. I'm looking for some help completing my finance project. (10% total course grade) There are quite a few questions. (40 total) I can check the answers one time before submitting. Hoping for...

I need with these problems/exercises listed below (chapters attached). You must use the chapters to fill out the guidance report which is attached. Using the data for March/April Column. Chapter...

Help needed with the following If you received $10,000 5 years back, what is its value today if the appropriate interest rate is 8% and interest is compounded monthly? At what annual rate of return...

Answers needed for #3-4, 9, 11, 13-17, 19-22, 29-32, 35-37, 40 FI 3300 - CORPORATION FINANCE Take-Home Problem Set Three (THPS-3) Fall 2015 Directions: This problem set covers chapters 6 and 7 in the...

P L E A E A N S W E R T H E F O L LO W I N G M AT H Q U E S T I O N S . QUESTION 1 1. Find the simple interest on a $400 investment made for 5 years at an interest rate of 7%/year. What is the...

A very thin round plate of radius R carrying a uniform surface charge density a is located in vacuum. Find the electric field potential and strength along the plate's axis as a function of a distance...

Give an example of an element of a product or process design that makes ieasy to do the right thing, and/or difficult or impossible to do the wrong thing, or that immediately detects when a mistake...

6. An application contains the Structure statement shown here. Write a Dim statement that declares a five-element one-dimensional array of MyFriend variables. Name the array home. Then, write an...

Binary Star-Different Masses two stars, with masses M, and M2, are in circular orbits around their center of mass. The star with mass M, has an orbit of radius R the star with mass M2 has an orbit of...

Raul Martinas, professor of languages at Eastern University, owns a small office building adjacent to the university campus. He acquired the property 10 years ago at a total cost of $530,000$50,000...

Molecular weight data for some polymer are tabulated here. Compute (a) The number-average molecular weight, and (b) The weight-average molecular weight. (c) If it is known that this material's degree...

PepsiCos financial statements are presented in Appendix A. Financial statements of The Coca-Cola Company are presented in Appendix B. Instructions (a) Based on the information contained in these...

The Near Earth Asteroid Rendezvous (NEAR), after traveling 2.1 billion km, is meant to orbit the asteroid Eros at a height of about 15km. Eros is roughly 40km x 6km. Assume Eros has a density...

Create a 200 word summary on the Juvenile Justice System than and today. Describe The Juvenile system and provide a generalizable definition. Highlight the issues in the Juvenile system and why this...

Dilutive effects of stock options. Refer to the schedule in Exhibit 12.6, which shows employee stock option data for General Electric Company (GE). At December 31. Year 3. employees held 2.7 million...

Reconstructing transactions involving shareholders' equity. Shea Company began business on January 1. Its balance sheet on December 31 contained the shareholders equity section shown in Exhibit...

Comprehensive review of accounting for shareholders' equity. The shareholders' equity section of the balance sheet of Alex Corporation at December 31 appears on page 719. a. Calculate the total book...