***Partially Completed Already***Please check the work that is already completed and make any changes needed (see attached).Ensure that ALL 6 steps below are completed. The Income statement and balance sheet for Camelot Inc. are provided here. Note that firm’s capital expenditures are expected to rise by $50,000 in the new year. This will lead to an increase of $5,000 in accumulated depreciation. Sales next year should be $4.3M1. Using percentage of sales analysis techniques prepare a pro forma income statement and balance sheet for the next year.2. Create a chart of sales by year for all years, including your pro forma estimate.3. Add a trend line.4. Create a scatter plot of sales vs. cogs. Add a trend line.5. Regress COGS against sales .6. Using your sales trendline and annual sales data forecast the sales level in the next 3 years (3 years after the year with 4.3M in sales). Forecast using the trend line as well as at least one of the following: trend, linest, regression.
Forecasting and Trends
How to place an order?
Take a few steps to place an order on our site:
- Fill out the form and state the deadline.
- Calculate the price of your order and pay for it with your credit card.
- When the order is placed, we select a suitable writer to complete it based on your requirements.
- Stay in contact with the writer and discuss vital details of research.
- Download a preview of the research paper. Satisfied with the outcome? Press “Approve.”
Feel secure when using our service
It's important for every customer to feel safe. Thus, at Your homework help service, we take care of your security.
Financial security You can safely pay for your order using secure payment systems.
Personal security Any personal information about our customers is private. No other person can get access to it.
Academic security To deliver no-plagiarism samples, we use a specially-designed software to check every finished paper.
Web security This website is protected from illegal breaks. We constantly update our privacy management.
Get assistance with placing your order. Clarify any questions about our services. Contact our support team. They are available 24\7.
Still thinking about where to hire experienced authors and how to boost your grades? Place your order on our website and get help with any paper you need. We’ll meet your expectations.