2022F MFIN1756 FP&A with Excel.
Final Project Assignment (50%).
Forecasted Financial Statements and Analysis Report.
Company Name:
Student Name:
- Company Analysis
1) Intro: Business Description &Industry Market Analysis
[Instruction. Research on any open resources and summarize with students’ own words. 2page long but not limited, including some figures, if any.]
…
2) Summarize Item 2 (Part I) on 10Q: Management’s Discussion and Analysis
[Instruction. Must include all the topics indicated on Item 2. Summarize each topic within a few sentences by students’ own words. Do not have to paraphrase all the contents. 5page long but not limited, including some figures, if any.]
…
2.List of explanations of all the input variables with assumptions,interpretations, and calculations on the forecasted financial statements.
[Instruction. All input variables, hard number inputs, and calculations on Excel part must be described in Word part. Hard input numbers on each cell on Excel should be explained by Where and Why this number can be applied. (Justified explanation by students’ own words with research citation) The input hard numbers should be explained by How this number is calculated with the clear process.]
1) Forecasted Income Statement
[Each quarter of all the income statemen items must be developed with research support, rather than just using the same % of sales throughout the forecasted quarters. Forecasted financial statements must be reasonable and realistic along with contemporary events and issues of the firm.]
- Sales
- Cost of Goods Sold
- …
- …
- …
- …
…
…
…
2) Forecasted Balance Sheet
[Tips! To get a higher grade, use as many independent assumptions on B/Saccounts in each quarter as possible with research support, rather than just using the same % of sales throughout the forecasted quarters. There are many B/S accounts that are not moving along with % of Sales. Forecasted financial statements must be reasonable and realistic along with contemporary events and issues of the firm.]
(1) Assets
- Cash
- Marketable Securities
- Accounts Receivable
- …
- …
…
…
(2) Liabilities
b.
c.
…
…
(3) Equities
b.
c.
…
…
3) Forecasted Statement of Cash Flows
[Instruction. Only interpretation is required of Cash Flows in Operating, Investing, and Financing. Interpret the main changes in the components of the activities.]
(1) Cash Flows in Operating
…
(2) Cash Flows in Investing
…
(3) Cash Flows in Financing
…
- Comparative Analysis with financial ratios
[Instruction. All the ratio sections on Excel part must be described in Word part. What changes will incur in the company for the forecasted period? Interpret and analyze the ratios throughout the quarters.]
1) Liquidity (Safety)
a.
b.
c.
- …
2) Productivity (Efficiency)
a.
b.
c.
- …
3) Profitability (Performance)
a.
b.
c.
- …
4) Insolvency (Leverage)
a.
b.
c.
- …
5) Dupont ratio analysis (overall interpretation)
6) Additional ratio analysis (at least 4more)
a.
b.
c.
- …
- Research policies regarding Ethics Sustainability & Responsibility (ESR) and Diversity, Equity, Inclusion & Belonging (DEIB) for the company you’ve chosen for the Final Project.
This is based on the Hult Academic Policy that mandatorily include ESR and DEIB in the course learnings.
- Summarize the policies and evaluate them by your own words in a Word file
- Turnitin % will be checked (significant Turnitin similarity may result in Honor Code Violation under AIC investigation)
- Two pages of summary and evaluation each for ESR and DEIB.