Costco company forecasting mode excel & report &presentation
We 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. only
Please 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 discussion
i. Provide an explanation as to the potential variance between your estimated share
price and the actual share price.
0 comments