***Partially Completed Already***<\/p>\n
Please check the work that is already completed and make any changes needed (see attached).<\/p>\n
Ensure that ALL 6 steps below are completed. <\/p>\n
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.3M<\/p>\n
1. Using percentage of sales analysis techniques prepare a pro forma income statement and balance sheet for the next year.<\/p>\n
2. Create a chart of sales by year for all years, including your pro forma estimate.<\/p>\n
3. Add a trend line.<\/p>\n
4. Create a scatter plot of sales vs. cogs. Add a trend line.<\/p>\n
5. Regress COGS against sales .<\/p>\n
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.<\/p>\n","protected":false},"excerpt":{"rendered":"
***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 Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-68146","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/68146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=68146"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/68146\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=68146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=68146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=68146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}