skip to Main Content
The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

Costco company forecasting mode excel & report &presentationWe are doing an accounting project which selected company is Costco.Company Selections
Students must select a U.S. firm listed on the New York Stock Exchange or NASDAQ. The firm
should use GAAP accounting, must have inventory, and must maintain debt in order to calculate
all of the necessary ratios. Avoid banks, insurance companies, companies that were recently part
of a merger, and conglomerates that conduct business in a multitude of industries (e.g., Amazon).
I would encourage teams to analyze “pure play” companies that focus on certain products or
operate within certain industries (e.g., Intuit).I am doing step 5 and 6. onlyPlease helps me complete the excel form and complete the sample report (word example)of step 5 and 6. Also,
prepare the presentation ppt slides which don’t need write too much in
the slide, only bullet point(4-5 slides?) and speech notes(about 6
minutes)5. Financial Forecasts (20 points) Step 5 – Project Future Financial Statements a. Forecast Models (12.5 points) i. 5-Year Revenue Forecast ii. 5-Year Income Statement Forecast iii. 5-Year Balance Sheet Forecast iv. 5-Year Cash Flow Statement b. Forecast Validation (2 points) c. Forecast Discussion (5.5 points) i. Provide explanations as to the various assumptions used to forecast each of the
respective models. Additionally, address any discrepancies highlighted in the
forecast validation. 6. Firm Valuation (10 points) Step 6 – Value the Firm a. Valuation model i. Create a financial model to determine the overall value of the firm. b. Per share calculation i. Determine the estimated per share value. c. Valuation discussioni. Provide an explanation as to the potential variance between your estimated shareprice and the actual share price.

GET HELP WITH THIS ASSIGNMENT TODAY

Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don’t hesitate to contact our live support team or email us right away.

How It Works        |        About Us       |       Contact Us

© 2018 | Intelli Essays Homework Service®