Calculate NPV based on discounted cash flow for supply of an item for a project
Budget: $10 – $30 USD
THIS IS A SIMPLE CASH FLOW DISCOUNTING PROJECT - NEED THE DELIVERY IN 1 DAY, PLEASE. Do not bid if you will take more than 1 day.
Please find attached a cash flow sheet for procurement of an Item (line pipe) for a project, and subsequent payment from buyer/client.
Please create a template based on following data:
1. Date (day) - editable, so for instance, if payment is received on day 140 instead of 120 days, then we should be able to change
2. Interest rate - dynamic field, so I should be able to enter teh interest rate (currently please take 12%)
3. NPV on Day 0 (31.01.2022)
Of course, the amount should also be editable, but please CREATE TWO worksheets - one using 100 as base, and 2nd using the amounts shown in the attached sheet (total inflow 22,65,03,360)
Please find attached a cash flow sheet for procurement of an Item (line pipe) for a project, and subsequent payment from buyer/client.
Please create a template based on following data:
1. Date (day) - editable, so for instance, if payment is received on day 140 instead of 120 days, then we should be able to change
2. Interest rate - dynamic field, so I should be able to enter teh interest rate (currently please take 12%)
3. NPV on Day 0 (31.01.2022)
Of course, the amount should also be editable, but please CREATE TWO worksheets - one using 100 as base, and 2nd using the amounts shown in the attached sheet (total inflow 22,65,03,360)