Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask linda_us Your Own Question

linda_us, Master's Degree

Category: Single Problem

Satisfied Customers: 787

Experience: A tutor for Business, Finance, Accounts and other related topics.

19873544

Type Your Single Problem Question Here...

linda_us is online now

This is an excel question projections: I'm trying to project

Customer Question

This is an excel question for calculating projections:I'm trying to project income for the remainder of the year and into July 31st of 2017. Here's my excel formula that I use for projections monthly and annually based on the number of sales days that my company has (306) using a period calendar. How would I do this on a monthly basis?Example of what I'm doing now YTD for each period: (B54) Jan Period 1 $268,489 (B55) Feb Period 2 $251,653 (B56) March Period 3 $253,215 (B57) April Period 4 $204,596 (B58) May Period 5 $288,460 (B59) June Period 6 $368,605 (B60) July Period 7 $246,038 (Note: Week of 4 of 4, 23 days in the period, day 20 of 23 days in the period, Sales Day 176) (B66) YTD $1,881,057 (Total of Periods 1 - 7 YTD as of July 27th) Mo Proj $272,794 (Excel: =(B60/20)*23 Where 20 is the 20th day of a period that has 23 days Annual Proj $3,270,474 (Excel: =B66/176)*306 Where 176 is sales day 176 of 306My goal is to project til the end of the year for the YTD amount. Do I take the total of $1,881,057 =(B66/7)*12 Where 7 is July or Period 7 and 12 is the 12 month or December?

Here it is again:I'm trying to project income for the remainder of the year and into July 31st of 2017. Here's my excel formula that I use for projections monthly and annually based on the number of sales days that my company has (306) using a periodcalendar. How would I do this on a monthly basis?Example of what I'm doing now YTD for each period: (B54) Jan Period 1 $268,489 (B55) Feb Period 2 $251,653 (B56) March Period 3 $253,215 (B57) April Period 4 $204,596 (B58) May Period 5 $288,460 (B59) June Period 6 $368,605 (B60) July Period 7 $246,038 (Note: Week of 4 of 4, 23 days in the period, day 20 of 23 days in the period, Sales Day 176) (B66) YTD $1,881,057 (Total of Periods 1 - 7 YTD as of July 27th) Mo Proj $272,794 (Excel: =(B60/20)*23 Where 20 is the 20th day of a period that has 23 days Annual Proj $3,270,474 (Excel: =B66/176)*306 Where 176 is sales day 176 of 306My goal is to project til the end of the year for the YTD amount. Do I take the total of $1,881,057 =(B66/7)*12 Where 7 is July or Period 7 and 12 is the 12 month or December?

What does YTD stands for and on what basis you want to project your sales, please provide me the ddetails not the example which you are doing, so I can try to explain you the way, thanks.

You don't know what YTD stands for? WOW! Okay, you're not the right person for me. If you don't know what YTD is you don't need to be answering a finance question.

It is not necessary for a person to know each and every abbreviation to become a finance expert, but if you don't want me to help you that is your wish, thanks.

YTD is the most common abbreviation that you could ever use in Finance. Again, if you do not know what this means, you have absolutely no business answering a finance question and taking money for it. WOW! WOW!