The XNPV function can calculate NPV for any(possibly irregular) series of cash flows. Look thisfunction up in Excel’s online help. Then use it todevelop a spreadsheet model that finds the NPV ofthe following series: a payment of $25,000 today(assumed to be June 15, 2014), and cash inflows of$10,000 on March 1, 2015; $15,000 on September 15,2015; $8000 on January 20, 2016; $20,000 on April 1,2016; and $10,000 on May 15, 2016. Discount theseback to “today” using a discount rate of 12%.

The XNPV function can calculate NPV for any(possibly irregular) series of cash flows. Look thisfunction up in Excel’s online help. Then use it todevelop a spreadsheet model that finds the NPV ofthe following series: a payment of $25,000 today(assumed to be June 15, 2014), and cash inflows of$10,000 on March 1, 2015; $15,000 on September 15,2015; $8000 on January 20, 2016; $20,000 on April 1,2016; and $10,000 on May 15, 2016. Discount theseback to “today” using a discount rate of 12%.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter14: Statement Of Cash Flows (cashflow)

Section: Chapter Questions

Problem 5R

See similar textbooks

Similar questions

The following set of cash flows has two internal rates of return. Calculate the 2nd IRR for the cash flows. (Enter percentages as decimals and round to 4 decimals). Hint: you will need to use a guess in the Excel function. Time 0 1 2 3 4 CF 8125 -17000 8000 -7500 9000
Q32 For the following organisation, calculate the undiscounted cash flow. You can do it in Excel and paste the result below. \table[[Year ,0,1,2,3,4,5
Create an Excel spreadsheet that calculates the internal rate of return for the following set of cashflows: Period 012345 Cashflow $1123.01 $100 $100 $100 $100 $ 1,100 Note your spreadsheet should calculate the present value of each of the individual cashflows as well as the sum based on your IRR input. Once you have completed your IRR calculation check your work with the Excel IRR function
Which of the following equation will allow you to solve for the ROR for the following cash flow? If the file failed to load, click https://www.dropbox.com/s/nuxqnt15nak2kdc/ROR-FE1.jpg Year 0 1 2 3 4 5 Cash Flow $15,000 0 $2,500 $5,000 $7,500 $10,000 O 15,000 2500(P/A, i*, 5) + 2500 (P/G, i*, 5) O 0= 15,000 + 2500(P/A, i*, 5) + 2500 (P/G, i*, 5) O 15,000 = 2500(P/G, i*, 5) O 0 15000 + 2500(P/G, i*, 5) O 15,000 2500(P/A, i*, 4) + 2500 (P/G, i*, 4) O 0 = 15,000 + 2500(P/A, i*, 4) + 2500 (P/G, i*, 4)
Present and Future Values of Single Cash Flows for Different Periods Find the following values, using the equations, and then work the problems using a financial calculator to check your answers. Disregard rounding differences. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent. An initial $600 compounded for 1 year at 6%. $ An initial $600 compounded for 2 years at 6%. $ The present value of $600 due in 1 year at a discount rate of 6%. $ The present value of $600…
a) Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Please show all dollar amount to thousands of dollars. b) On another sheet, create a statement of cash flows for 2019. Do not enter any numbers directly on this sheet. All formulas should be linked directly to the source on previous worksheets.
How to make monthly cash flow statement in Excel. Give me an example.
Please see attched problem problems should be solved by using a financial calculator or MS excel spreadsheet. Accordingly, you must show the values of all relevant time valu of money variables
The rate of return for the following cash flow is closest to: If the file failed to load, click https://www.dropbox.com/s/nuxqnt15nak2kdc/ROR-FE1.jpg If you decided to use Excel to solve this problem, be aware that you will need to solve in by hand in Exam 2. Year 0 1 2 3 4 5 O 10% O 12% O 14% O 16% Cash Flow - $15,000 0 $2,500 $5,000 $7,500 $10,000
Given the following cash flows and a discount rate of 9.5%, the net present value is closest to: $ CFO (27.50) 2$ $ $ CF1 8.75 CF2 11.30 CF3 14.90 Select an answer and submit. For keyboard navigation, use the up/down arrow keys to select an answer. $1.26 b $28.76
The NPV function automatically discounts each of the cash flows and sums the discounted values. Verify that it does this correctly for Acron’s model by calculating the NPV the long way. That is, discount each cash flow and then sum these discounted values. Use Excel formulas to do this, but don’t use the NPV function. (Hint: Remember that the discounted value of $1received t years from now is 1y(1 1 r)t dollars today.)
I need this explained in detail, I have tried to solve it multiple times but know I am adding or subtracting something incorrectly. You can use the cash flow statement with different colored pens for the questions and just put a + or - to tell me if you added or subtracted. As much detail as you can go in as I learn best by looking at questions and seeing how the answer was gotten. Additional Information for MKH Co. in 20X1:1. Net income for year 20X1 was $216,000.2. The company declared and paid a cash dividend of $132,800.3. The only posting to the net equipment account was for depreciation expense of $35,000 (i.e., no equipment was sold).4. MKH sold land worth $19,200 for $8,000 cash.5. The company retired $148,400 worth of bonds payable at the beginning of the year. 1. What was the loss on the sale of land recorded by MKH Company in 20X1? $11,200 $8,000 $0 $19,200 2. What were MKH Company's cash flows from…