Get instant live Excel expert help to learn how to apply financial function in Excel?

not able to sum based on criteria? What is the total projected depreciation for 2019 fiscal year for location_id 11200?

I need to create a formula for calculating cash flows in certain conditions.

How to calculate the Running Total of net cash flows using the quick analysis tool without typing in the formula

What is the NPV assuming cash flows all come at the end of each period? Expert_777

Worksheet Q44-45 What is the NPV assuming cash flows all come at the end of each period?

I need a solution in excel, I have attached my request. I need to find a solution where the cash flows compensate for the constuction period so that the IRR is not effected

I am trying to calculate IRR for a deal where the sign changes - below are the example cash flows: 7/17/2012 - (40,984) 8/15/2013 - 33,925 6/30/2014 - (6,341) 12/22/2014 - 3,047 12/31/2017 (Terminal Value) - 0 The XIRR formula is telling me the value is -24.46%, but it does not make intuitive sense to me that this number could be right given its over 4 years and 80% of the value has been recovered. Could you please advise on if the formula works in this type of scenario where signs change, or if there is something else you need to consider in this scenario?

Need help with npv calculator excel. How do I calculate the NPV and IRR of future MONTHLY cash flows using an annual rate? How do I convert to monthly rate?

I'm laying out cash flows for several projects across many years. I would like the spending columns to start filling with a fixed proportion of the budget across a year in the first payment month, i.e. one month after the start month. I would also like the sheet to figure out monthly bank re-payments after a building completion date and when both downpayment and final payment have been received. When the sales actually happen should be able to changed. A sheet is attached.

The Monthly cash flows in row 13 are a portion of the total budget $Q$8. I want them to be put in the right place along the monthly columns based on inputs. They should start and finish in row 13, based on $r$4 and $r$5 and in proportion to the 14 month spending plan specified in row 8. In other words I should be able to change to the start date R4, numer of months to sign -off R5, and/or the spending percentages columns U to AH, with the cash flows being in the right columns of Row 13. ... with the same commands I presume, I would also like to Completion Date Cell to move along row 4 (or even row 3) to the correct column location.