HomeworkLib
Question

Using PV function in Excel. Cant get to generate the right answer for PV, Annuity and NPV formulas. It should be 7462.20, just like the sum of All PV.

2) Find the present value of a 10 year annuity due of $1,200 with 12% APR and quarterly compounding Requirement: Calculation and output sections must update automatically with changes in data input. Update shaded cells with formulas and functions. Data Input Cashflow Rate Discount Rate Periods S1,200 12% 12.55% 0.12550881 10 Period> Cashflow Present Value 0 5 6 10 $1,200.00 $1,066.18 $947.29 $841.66 $747.80 $664.41$590.32 $524.49 $46 $414.04 $0.00 Output methods Sum of all PV Using PV Function Using NPV Function Using Annuity Formula $7,462.20

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy. B า 프 . Ej- a-Δ. : rーー 逻锂函Merge & Center. $ % , to: conditional Format . Cell Insert Delete Formsat Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard Alignment Number Cells M18 2 CASHFLOW 3 RATE 4 DISCOUNT RATE 5 PERIODS 1200 12% 12.55% 10 7 PERIOD 8 CASHFLOW 9 PRESENT VALUE 10 11 OUTPUT METHODS 12 SUM OF ALL PV 13 USING PV 14 USING NPV 15 USING ANNUITY 16 17 18 19 /4 NOTE BIDDING, UNDERWRITING (EUAC AV PM LIFE 0 1200 4 6 10 1200 1200 1066.18 947.29841.66 747.80 664.41 590.32 524.49 466.00 414.04 1200 1200 1200 1200 1200 1200 1200 1200 7462.20 7462.20 7462.20 7462.20 PV(M4,M5,-M2,,1) A/r*(1-(1/(1+r)An))*(1+ ANNUITY DUE FORMULA (1200/0.12550881)(1-(1/(1+0.12550881)A10)) (1+0.12550881) LP, lp MRP INFLATION YIELD WARRANTrefund bond CLEAN INVOICE PRICE . Sheet1 . Sheet3 Sheet4 05:58 29-01-2019

0 0
Add a comment
Know the answer?
Add Answer to:
Using PV function in Excel. Cant get to generate the right answer for PV, Annuity and...
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 complete parts A and B using Excel (see template below in pic 2), explaining the...

    Please complete parts A and B using Excel (see template below in pic 2), explaining the steps and writing out the Excel formulas. You just won a prize of $5,000 at the local talent show. You can receive the money all up front (t=0), or get a series of monthly or weekly payments as described below. In all cases, your discount rate is 5% APR (annual percentage rate). You may choose to get 39 monthly payments, with the first payment...

  • This homework question requires that you complete the Excel file entitled "HW#2 Template Spring2019.xlsx found on...

    This homework question requires that you complete the Excel file entitled "HW#2 Template Spring2019.xlsx found on Courseweb. Once you have completed it, print it and attach it to your homework submission with the first six questons. You just won a prize of S5,000 at the local talent show. You can receive the money all up front (t-0), or get a series of monthly or weekly payments as described below. In all cases, your discount rate is 5% APR (annual percentage...

  • Provide the missing information for the following projects using the present value of an annuity function...

    Provide the missing information for the following projects using the present value of an annuity function [time value of money (TVM) keys rather than the cash flow (CF) function keys]. (Hint: The present value of the annuity of the annual cash flows minus the initial outlay must equal the NPV. For example, for Project A, calculate the present value of five $35,000 cash inflows and subtract the initial outlay (Co) to get the project's NPV.) Inltlal Outlay (CO) Length (In...

  • Please answer in excel formula format. This is the full question with all the information. Bill...

    Please answer in excel formula format. This is the full question with all the information. Bill Clinton reportedly was paid $15 million to write his book My L . Suppose the book took three years to write. In the time he spent writing, Clinton could have been paid to make speeches. Given his popularity, aume that he could earn $8 million per year (paid at the end of the year) speaking instead of writing. Awame his cost of capital is...

  • Need help with excel. The right answers are shown. Dont know what to input to get...

    Need help with excel. The right answers are shown. Dont know what to input to get those answers. 3) Assume that the answer in B20 is the price you must pay to purchase the bond today and take it as a data input in the following problem. Find the IRR of the bond investment. Refer to Question 1 for the other inputs. Period (0.5Year) Bond investment Expected cash flow from bond investment Incremental cash flow (Bond INV Output Using IRR...

  • Ch 14 Excel Simulation G 1 Calculate the price of a bond using the Excel PV...

    Ch 14 Excel Simulation G 1 Calculate the price of a bond using the Excel PV function. Bond Pricing- Excel 4 Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEWVIEW Calibri 11 A A B IU-AAlignment Number Conditional Format as Cell Cells Editing FormattingTableStyles- A1 vXOn January 1, Ruiz Company issued bonds as follows: 1 On January 1, Ruiz Company issued bonds as fbllows: 2 Face Value 500,000 3 Number of Years: 4 Stated Interest Rate: 7% 5 Interest...

  • a.   Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer...

    a.   Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by using the Excel function wizard. Inputs: PV = 1000 I/YR = 10% N = 5 Formula: FV = PV(1+I)^N = Wizard (FV): $1,610.51 Note: When you use the wizard and fill in the menu items, the result is the formula you see on the formula line if you click on cell E12. Put the...

  • ANSWER ASAP PLEASE Using only the standard input/output function fgetc(), define a C function, called int...

    ANSWER ASAP PLEASE Using only the standard input/output function fgetc(), define a C function, called int readInt(int *value), that reads an integer from the keyboard (stdin), stores it in *value and, returns 1 for success or 0 for fail (in case the user enters nondigit characters). In particular, readInt() reads all characters, one by one, until a blank (or newline) is encountered. The string is then converted to an integer. It is also possible to have the sign charcater (+/-)...

  • Bond Pricing Using Tables Bond Pricing Using Tables 1. Calculate the price of a bond using...

    Bond Pricing Using Tables Bond Pricing Using Tables 1. Calculate the price of a bond using tables. D Bond Pricing - Excel 7 - X . . HOME FILE INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in B T U . A Alignment Number - Cells Editing Paste Clipboard A1 3- Font Conditional Format as Cell Formatting Table Styles Styles X 1 On January 1, Ruiz Company issued bonds as follows: 1 On January 1, Ruiz Company issued bonds...

  • Chapter 10 Excel Saved Help Save & Exit Submit Ruiz Company issued bonds on January 1...

    Chapter 10 Excel Saved Help Save & Exit Submit Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel's Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. 10 points (8 02:46:24 eBook Print References • Cell Reference: Allows you to refer to data from another...

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