Question: please solve this questions using excel (I,N,PMT,PV,FV) - How much you need for an ordinary annuity of $3,000 paid every six months for 13 years

please solve this questions using excel (I,N,PMT,PV,FV)

- How much you need for an ordinary annuity of $3,000 paid every six months for 13 years if you could invest your money elsewhere at an interest rate of 8% compounded semi-annually?

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!

Q:

See attached assignment for full set of questions. Below are a few examples of questions: What would the future value of $500 be after 5 years at 10% compound interest? At 10% simple interest?...

Q:

See attached assignment for full set of questions. Below are a few examples of questions: What would the future value of $500 be after 5 years at 10% compound interest? At 10% simple interest?...

Q:

See attached assignment for full set of questions. Below are a few examples of questions: What would the future value of $500 be after 5 years at 10% compound interest? At 10% simple interest?...

Q:

See attached assignment for full set of questions. Below are a few examples of questions: What would the future value of $500 be after 5 years at 10% compound interest? At 10% simple interest?...

Q:

Hi, Can someone solve these questions and include the formula or calculator functions/excel used. 1. A factory owner decides to start setting aside money in order to upgrade some equipment at the end...

Q:

3 This assignment covers material from Units 8 to 9 in the Mathematics 244 Study Guide. It is due after Unit 9 in the Study Guide is completed. Total Marks = 100 Business Mathematics 1. What is the...

Q:

Summary of Key Formulas A copy of this summary of Key Formulas will be attached to exams. On assignments and exams show all your work. This allows the marker to assess partial marks. Show the...

Q:

1 This assignment covers material from Units 1 to 4 in the Mathematics 244 Study Guide. It is due after Unit 4 in the Study Guide is completed. Total Marks = 150 1. Evaluate each of the following...

Q:

I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to...

Q:

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Q:

Madison Outlet has the following inventory transactions for the year: + Date Transaction Number of Unites Unit Cost Total Cost Jan 1 Beginning 10 $200 $2,000 inventory Mar 14 Purchase 15 300 4,500...

Q:

Complete the following equation. Using Table 15.2, predict whether you would expect the reaction to occur to any significant extent or whether the reaction is more likely to occur in the opposite...

Q:

Why is life insurance such an important planning device for an estate plan? What is the function of an irrevocable life insurance trust?

Q:

Background Allgood Incorporated is considering purchasing a new machine to replace a current machine. The new machine will cost $390,000 and use working capital of $9,000. The current machine can be...