Single Problem

Get Single Problem Homework Help from Experts

Get an Answer ASAP!

Single Problem

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

Customer Question
This is an excel 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?
Submitted: 1 year ago.Category: Single Problem
Show More
Show Less
Answered in 9 minutes by:
7/27/2016
Business Tutor: F. Naz, B.Com replied 1 year ago
F. Naz, B.Com
Category: Single Problem
Satisfied Customers: 5,346
Experience: Have completed B.Com and CA Finalist
Verified

Hello

Is this your home work or some real scenario?

Customer reply replied 1 year ago
Does it matter? It's a real scenario.
Business Tutor: F. Naz, B.Com replied 1 year ago

Of course it matter because it will help me to answer your question, please explain what you require exactly?

Customer reply replied 1 year ago
Please reread my question. It is very detailed.
Customer reply replied 1 year ago
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?
Business Tutor: F. Naz, B.Com replied 1 year ago

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.

Customer reply replied 1 year ago
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.
Business Tutor: F. Naz, B.Com replied 1 year ago

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.

Customer reply replied 1 year ago
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!
Business Tutor: F. Naz, B.Com replied 1 year ago

It stands for Year to Date, now happy?

linda_us, Master's Degree
Category: Single Problem
Satisfied Customers: 787
787 Satisfied Customers
Experience: A tutor for Business, Finance, Accounts and other related topics.

linda_us is online now

A new question is answered every 9 seconds

• Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
• Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
• 100% Satisfaction GuaranteeRate the answer you receive.

## JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

## What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

## Meet the Experts:

linda_us

Master's Degree

787 satisfied customers

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

Manal Elkhoshkhany

Bachelor's Degree

491 satisfied customers

Finished my BA degree with a GPA of 4.0.

F. Naz

B.Com

5,346 satisfied customers

Have completed B.Com and CA Finalist

Mr. Gregory White

Master's Degree

279 satisfied customers

M.A., M.S. Education / Educational Administration

Bizhelp

CPA

265 satisfied customers

BA degree and Certified Public Accountant

Dave CPA

Accountant

98 satisfied customers

Sound knowledge base in accounting and finance.

MyVirtualCPA

Master's Degree

96 satisfied customers

Master's Degree in Accounting with excellent math and reasoning skills

< Previous | Next >

Related Single Problem Questions
Ben is 46 and unmarried his mother Susan age 81 lives in a
Ben is 46 and unmarried his mother Susan age 81 lives in a nursing home Ben pays the entire cost of the nursing home and more than 50%of Susan's total support Ben wages were \$75000.00 and Susan income… read more
TaxRobin
Vocational, Technical or Trade School
1 satisfied customers
Using round numbers, \$80k is the standard deduction under
Using round numbers, \$80k is the standard deduction under AMT for taxpayers who are married, filing jointly. And \$160k is the threshhold for phasing ours the deduction. However, I have not been able t… read more
F. Naz
B.Com
5,346 satisfied customers
What is the final amount of \$105.00 that is put into a
What is the final amount of \$105.00 that is put into a savings account work 8% interest rate for 25 yesterday, if the interest is compounded 4 times a year? … read more
Dr. Donna Kakonge
Doctor of Education
193 satisfied customers
I am self-employed. I relocated temporarily to so I can work
I am self-employed. I relocated temporarily to Virginia so I can work while my home recovers from hurricane. I read the IRS allows deductions for temporary housing and transportation costs as business… read more
Barbara
Enrolled Agent, Paralegal
3,490 satisfied customers
Florida Home Health is a small home care agency owned by a
For Manal Elkhoshkhany Florida Home Health is a small home care agency owned by a group practice of nurses and physical therapists in Tampa, Florida. During the past few years, the company reported th… read more
Manal Elkhoshkhany
Bachelor's Degree
491 satisfied customers
You are the resident tax expert for Wetzel's Pretzels, an
You are the resident tax expert for Wetzel's Pretzels, an international producer of junk food. The controller has come to you with the company's capital expenditures budget for next year. The budget s… read more
Manal Elkhoshkhany
Bachelor's Degree
491 satisfied customers
Hand written tax return #4 is not in the book and it's NOT
Hand written tax return #4 is not in the book and it's NOT hand written. Please do this return on the COMPUTER, but this is not a group tax return! Please do this on your own. The information is in th… read more
Dr. Donna Kakonge
Doctor of Education
193 satisfied customers
You are the resident tax expert for Wetzel's Pretzels, an
You are the resident tax expert for Wetzel's Pretzels, an international producer of junk food. The controller has come to you with the company's capital expenditures budget for next year. The budget s… read more
F. Naz
B.Com
5,346 satisfied customers
In problem 89 of Chapter 9, you were asked to determine the
In problem 89 of Chapter 9, you were asked to determine the initial basis of Emelio and Charita's business, investment, and personal use assets. In this problem, you are to determine the adjusted basi… read more
Manal Elkhoshkhany
Bachelor's Degree
491 satisfied customers
You are the resident tax expert for Wetzel's Pretzels, an
You are the resident tax expert for Wetzel's Pretzels, an international producer of junk food. The controller has come to you with the company's capital expenditures budget for next year. The budget s… read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
INCLUDE THIS ******* AS A FIRST NAME JASPER ******* AS A
PLEASE INCLUDE THIS DAVID ******* AS A FIRST NAME JASPER ******* AS A LAST NAME Please read the entire problem for David and Darlene Jasper starting on pages 6-69 before entering any information in yo… read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
Develop a progressive yet competitive compensation plan that
Develop a progressive yet competitive compensation plan that will support recruiting and retention efforts and lower the employee turnover rate. Traditionally, Motors and More has provided employees m… read more
Dr. Donna Kakonge
Doctor of Education
193 satisfied customers
I like to address this to a teacher. Who has or is teaching
Hello: I like to address this to a teacher. Who has or is teaching at the Community College level. Or a school administrator at the Junior College level. This is my 3rd semester at San Diego City Coll… read more
Dr. Donna Kakonge
Doctor of Education
193 satisfied customers
FOR MANAL ELKHOSHKHANY Assignment Steps Resources: OECD
FOR MANAL ELKHOSHKHANYAssignment Steps Resources: OECD Database, Corporate Finance Prepare a 12- to 15-slide PowerPoint® presentation with speaker notes requesting initial funding of \$500,000 to start… read more
Dr. Donna Kakonge
Doctor of Education
193 satisfied customers
You are to submit the tax return which is generated by
You are to submit the tax return which is generated by Appendix A, Phases One and Two. Phase Two builds on Phase One. Pay close attention, because some of the new information in Phase Two may change t… read more
Manal Elkhoshkhany
Bachelor's Degree
491 satisfied customers
I'm replacing the wheles on a bed frame. I need to replace
I'm replacing the wheles on a bed frame. I need to replace the plastic inserts that go into the frame so the caster stems fit and swivel. What are the plastic inserts called? I want to order them but … read more
F. Naz
B.Com
5,346 satisfied customers
On January 1, 2014, Seller Corp and Buyer Corp closed on the
On January 1, 2014, Seller Corp and Buyer Corp closed on the sale of a factory building for \$30,000,000 with the following payment terms: Buyer Corp paid \$3,000,000 at closing. Buyer Corp assumed \$7,0… read more
F. Naz
B.Com
5,346 satisfied customers
Question #4. New Beginnings Corp. began 2XXX with the
Question #4. New Beginnings Corp. began 2XXX with the following account balances. … read more
Dr. Donna Kakonge
Doctor of Education
193 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less