Question: pls solve this question 2 on Excel [2] PV (Present Value) = PV(rate,nper,pmt, Fv type) PV(i%,n,A,Fv) Problem:: i= 8% per year, n= 36 months, A=$

pls solve this question 2 on Excel

[2] PV (Present Value) = PV(rate,nper,pmt, Fv type) PV(i%,n,A,Fv) Problem:: i= 8% per year, n= 36 months, A=$ 300, FV=$12000 & type: payments are made at the end of a period. Find the present value? F=$ 12000 A= $300 Months 2 3 4 5 35 36 i=8%/12 P=? Also use the following equations to find the present worth (Hand calculations &Excel sheet). Po=A Po=F(1+i)" Ans. $19020.60

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!

Part 1: Read the following information JIN Corporation is about to make an investment. Among many potential projects, there is one very profitable. Before the company makes decision, you are asked to...

Excel Financial Formula Project The attached printout of an Excel spreadsheet shows the use of six financial formulas related to the time-value-of-money concepts discussed in Chapter 5. Your task is...

Please show the answers neatly in Microsoft Excel, thank you Question 2 (a) The calculation of present value (PV) or future value (FV) involves specifying the discount rater and the compounding...

I am having a hard time answering the tabs 5 thru 7 on the attached excel spread sheet. I am new at this and would love to be able to use it as an example going forward. Can you help me complete so I...

Need help filling out the finance workheets attached. Adapted by Robert Timmons, D.B.A. 2010 - 2015 Managerial Finance BUS 8003 Chapter 4 Selected Problems 2-26 Printer Friendly NOTE: The problem...

if possible say what formulas to use in excel wala Review View Tell me Garamond 12 AA Py Wrap Text General BTW THIDO Merge & Center $ - % C D H 1 Pe Th Project 1: A company that manufactures bicycles...

Pleese only on excel Formative 1 week 2 Find the solutions for the below exercises using Excel, at the end of the assessment you have to present the Excel sheet Financial functions: = PMT ( rate;...

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...

I was looking at the solution to the following question on this site. I could not understand why use 12 when working out the NPER. Since the monthly payments start 1 month after should you not use...

SOMEONE PLEASE HELP ME GIVE ALL THE ANSWERS!!!!! MY EXAM IS ON 13th MORNING! SO PLEASEEEEE!!!!! 2. An investment is expected to pay the following: C 1 = $2,300, C 2 = $2,600, C 3 = $2,900, and then...

Briefly define the seven RAID levels. Discuss.

Luis created a macro to insert a plain worksheet title, and then attached the macro to the Insert Title button. He no longer needs the button. Delete the Insert Title button in the range H5:H6 I am...

What amount will Jose need to have today to guarantee an annual payment of $ 2 , 7 7 8 , in today's dollars, at the start of each year for 1 7 years? Assume interest rates are 5 . 7 1 % . What is the...

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

Technology. Construct a visual aid showing the grades you have in this course. Send the visual to your teacher as an attachment to an e-mail. (Objective 4)

Explain three flaws in development of graphs that could mislead the reader. (Objective 6)

Technology. Use the Internet to locate an annual report or other written report from a major corporation that includes visual aids.Write an analysis of the report, including the following...