HomeworkLib
Question

Which Excel option below is equivalent to the factor (A/F, 5%, 7)? A. PV(5%, 7, 0,...

Which Excel option below is equivalent to the factor (A/F, 5%, 7)?

A.

PV(5%, 7, 0, 1, 0)
B.

FV(5%, 7, 1, 0, 0)
C.

PV(0.05, 7, 1, 0)
D.

PMT(5%, 7, 1, 0, 0)
E.

PMT(5%, 7, 0, 1, 0)
business   economics   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Option E

The factor A/F implies annual equivalence over future amount and PMT is the correct function for periodic payment. Next we see that rate = 5% and time or NPER is 7 which means both RATE and NPER are correctly placed. Next is PV which is 0 in this case and then we have FV which is positive in this case. So FV is 1 and PV is 0.

0 0
Add a comment
Know the answer?
Add Answer to:
Which Excel option below is equivalent to the factor (A/F, 5%, 7)? A. PV(5%, 7, 0,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Please show the formula and answer in Excel f.   Find the PV of an ordinary annuity...

    Please show the formula and answer in Excel f.   Find the PV of an ordinary annuity that pays $1,000 at the end of each of the next 5 years if the interest rate is 15%. Then find the FV of that same annuity. Inputs: PMT = $      1,000 N = 5 I/YR = 15% PV: Use function wizard (PV) PV   = FV: Use function wizard (FV) FV   =

  • Problem 1.10 INPUT PV= $      6,000.00 FV= $    10,000.00 RATE= ? TIME= 5 PMT= 0 OUTPUT RATE= #NUM!...

    Problem 1.10 INPUT PV= $      6,000.00 FV= $    10,000.00 RATE= ? TIME= 5 PMT= 0 OUTPUT RATE= #NUM! Problem 1.13 INPUT PV= $         30.00 FV= $         60.00 RATE= 7% TIME= ? PMT= 0 OUTPUT TIME= 　 Problem 1.17 INPUT PV= $            -    FV= $   120,000.00 RATE= 5% TIME= 18 PMT= 0 OUTPUT PMT= 　 On the Excel, Is there any order to put first? for example, =Rate(-PV,FV,TIME,PMT) Like that kind of order? I put this way, but it shows up like that (#NUM!) Also, PMT order, Time order...

  • Calibri (Body) abc Wrap Tex Number % ting Future Val Nm Interest Rate FV inerest Factor...

    Calibri (Body) abc Wrap Tex Number % ting Future Val Nm Interest Rate FV inerest Factor 2.5937 $8752 $7685 S183,796 $2,500,000 0 0 OPINIMIS ante Future Value of $1 (PV) int periods: pmt = 0 Excel Formula Viratenpar. O. D) This is called Future Value Interest Factor (FVIFY For Example =FV(10%.10,0,1) is FV for $1 today in 10 yrs @10% 2.5937 =FV(10%/365,365,0.-1) 1.1052 APR A N NA

  • [Refer to the first venture (Intertactical-See reference below). Use Excel built-in functions, include in the Excel...

    [Refer to the first venture (Intertactical-See reference below). Use Excel built-in functions, include in the Excel file.] (a) Use PV function to calculate the present worth (i.e., at time zero) of each year’s CF. Find the total present worth. (b) Use NPV function to calculate the present worth (i.e., at time zero) of the venture. (c) Use FV function to calculate the future worth (i.e., at year 5) of each year’s CF. Find the total future worth. (d) Use PMT...

  • use excel, do it like this PV= FV= PMT= N= I/Y= IN= 1. A Real Estate...

    use excel, do it like this PV= FV= PMT= N= I/Y= IN= 1. A Real Estate Investor is considering the purchase of an apartment building. The investor estimates the current value at $400,000. If the market price appreciates at 8 percent annually what will be the price of the unit at the end of 5 years? 2. Suppose you were selling your home. A buyer has offered to pay you $115,000 now and another $85,000 in 2 years. What is...

  • What are the three approaches to solving this problem? Sample Excel Quiz #1B/Test #1 Question Problems...

    What are the three approaches to solving this problem? Sample Excel Quiz #1B/Test #1 Question Problems in Business Finance 382, Test 1, Q12., Fall 2009 Q2a. Your old college roommate, Dennis Haydell (F382, Fa'09) is trying to get his start- up business off the ground and is looking for investment capital. If you lend him $35,000 today he has promised to make semi-annual repayments of $7.456.57 over three years. Make the appropriate calculation to determine if you should accept this...

  • 2. Which statements about Excers FV function are correct? 0 The FV function has five arguments,...

    2. Which statements about Excers FV function are correct? 0 The FV function has five arguments, and their abbreviations are rate ner pm, p and type ○ If the number for the pmt argument is entered as a postive value and the pw value is zero, the F 0 If the interest rate is 10%, the rate argument can be enered as 1 or 10% 0 Alofthe options are correct. value is negative. 3. Which fields are required to calculate...

  • You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....

    You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly. The loan will be repaid in 5 years with monthly payments. What is your monthly payment (calculated with the equations on the next page)? Compare your answer to that obtained with the built in function, PMT. Be sure to label all cells appropriately. (There is no need to create a monthly payment table, simply use the equations on the next page.) Loans: where: and,...

  • Use Excel.. (PV, FV, or PMT) The table below represents the annual earnings from Tina's Trading...

    Use Excel.. (PV, FV, or PMT) The table below represents the annual earnings from Tina's Trading Company, a mid-size manufacturing company. Annual earnings are reinvested into an account which earn 9.7% interest annually. What is the company's retained earnings account at the end of the last period? Net CF FV Year 2012 2013 2014 2015 2016 2017 2018 $ $ $ $ $ $ $ Income Expense 350,000.00 $ 155,000.00 413,678.00 $ 118,745.00 202,341.00 $ 121,713.63 213,469.76 $ 124,756.47 225,210.59...

  • Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question...

    Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT