ZuoTi.Pro
Question
what formula should i put in M17
Number of Shares Sold 294.00 1 END OF YEAR Total Value TOTAL Total Shares Sell Amount Cash on of All Equity (End Held (End of
Styles Clipboard Font UPDATES AVAILABLE Updates for Office we ready to be installed, but first we need to close some 800 M17
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

NPV (NET PRESENT VALUE) GENERAL SYNTAX IS

=NPV (rate, value1, [value2], ...)

  • rate - Discount rate over one period.
  • value1 - First value(s) representing cash flows.
  • value2 - [optional] Second value(s) representing cash flows.

Hence formula for M17 is,

=NPV(C1,M7:M15)+M6

If the first cash flow occurs at the start of the first period(YEAR 1), the first value (M6)must be added to the NPV result, not include in the values arguments.

0 0
Add a comment
Know the answer?
Add Answer to:
what formula should i put in M17 Number of Shares Sold 294.00 1 END OF YEAR...
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

  • *First, what is the annual operating cash flow of the project for year 1? *What is...

    *First, what is the annual operating cash flow of the project for year 1? *What is the annual operating cash flow of the project for year 2? *What is the annual operating cash flow of the project for year 3? *What is the annual operating cash flow of the project for year 4? *What is the annual operating cash flow of the project for year 5? *Next, what is the after-tax cash flow of the equipment at disposal? *Then, what...

  • 1: What is the operating cash flow for this project for the first five years of the 10-year period?? 2: for the last...

    1: What is the operating cash flow for this project for the first five years of the 10-year period?? 2: for the last five years of the 10-year period? 3: What is the book value? 4: Calculate the gain or loss at disposal of the manufacturing equipment. 5: What is the after-tax cash flow at disposal? 6: What is the net present value? NPV, Migliotti Restaurants is looking at a project with the following forecasted sales: first-year sales quantity of...

  • 1. Ten years ago, the Circus Corp. sold a 20-year bond issue with a 9 percent...

    1. Ten years ago, the Circus Corp. sold a 20-year bond issue with a 9 percent annual coupon rate and a 3 percent call premium. Today, Circus called the bonds. The bonds originally were sold at their face value of $1,000. Compute the realized rate of return (yield to call) for investors who purchased the bonds when they were issued and who surrender them today in exchange for the call price. 2.   (EXCEL TEMPLATE) Grass Whacker’s is considering whether or...

  • Walmart has 11,000 million shares authorized What percentage of authorized shares was issued by Amazon at...

    Walmart has 11,000 million shares authorized What percentage of authorized shares was issued by Amazon at December 31, 2015, and by Wal-Mart at January 31, 2016? (Round answers to 1 decimal place, e.g. 52.5%.) Amazon Wal-Mart Percentage of authorized shares issued % % How many shares are held as treasury stock by Amazon at December 31, 2015, and by Wal-Mart at January 31, 2016? (Enter answers in millions. If answer is zero, please enter for the amount. Do not leave...

  • Ch 1 1. Given the following dat Dec 31 Year 2 Dec 31 Year 1 Total...

    Ch 1 1. Given the following dat Dec 31 Year 2 Dec 31 Year 1 Total liabilities S128,250 $120,000 Total stockholders oquity 95.000 80.000 compute the ratio of liabilities to stockholders' equity for each year Round to two decimal places 1.50 and 107, 11.35 and 1.50 respectively respectively 1.07 and 1.19. 1.1.19 and 1.35 respectively respectively The liabilities and stockholder's equity of a company are $132,000 and $244.000, respectively. Assets should equal SS188.00 $132.00 p $376,00 12.000 A financial statement...

  • 1. Financial Statements: Develop an Income Statement for 20XX, Cash Flow Statement for 20XX, and Balance Sheet as of the end of 20XX based on the data provided below for year 20XX. All sales are colle...

    1. Financial Statements: Develop an Income Statement for 20XX, Cash Flow Statement for 20XX, and Balance Sheet as of the end of 20XX based on the data provided below for year 20XX. All sales are collected when the sale is made and all expenses are paid when the expense is incurred. Explain the purpose of each financial statement. a. Income Statement Data for 20XX: • Units produced and sold = 420 • Sales ($80 per unit selling price) = $33600...

  • please help with question 2 on the ratio analysis tab. I am attaching all tabs to...

    please help with question 2 on the ratio analysis tab. I am attaching all tabs to help. thanks A B C D E F G H I Instructions 1. Please enter the data from the previous tabs by clicking on the cell and typing and then clicking on the desired cell. For example to enter Net Income for 2018 type and go to the income statement tab and click on cell 127. 2. Complete the calculations. 3. Explain the significance...

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
ADVERTISEMENT