revenue projections

Hi I need to calculate compound interest with the following variable The principal value is : 100000 Now I need to calculate in row the following 1st year PV : 100,000 at 4% interest rate 2nd Year PV (100000 fixed) + (100000 X 4% PA) So and so forth till 15 yrs. I need this information all in...

Hi Everyone, I'm working on a cashflow projection and for that I need to determine a realistic date for collections. I have a list of invoices issued to customers, each with corresponding due date. However, many customers disregard the due date and pay according to their established payment...

I have created some projections assuming the initial month is February 2020. I would like to have a manual fill cell wherein a month can be typed and all the data will shift as if that typed month is the initial month. In other words, if I type May 2020 in the fill cell, all data which...

Hey Everyone, I work for a call center of Inbound Sales agents and I'm looking to set up a tool that will allow our leadership team to project what the Sales agent's Month-to-Date Revenue will be based on their current performance during that month so far. This will assist them in their...

My first post, so sorry for the format of question if wrong. I have created a (in Excel 2010) basic rolling calendar on which I project revenue recognition splits based on in-bound work mix. Projects come in about 14 types, each type has a fixed price, and the total ordered projects each day...