I’ve attached a complete instruction document. It has everything you need, company backgrounds, financial assumptions and step-by-step guidance. You only ned to pick one of the 3 scenarios and ONE, build the DCF model in Excel and calculate NPV and IRR. Also, can you please complete these tasks.
- Written Report ( 2,500 words max) containing:
-
- Company & industry overview ( 250 words)
- Separate, clearly labeled sections for Tasks 16
- Summary of key findings & recommendations ( 300 words)
- Excel file with:
-
- DCF model (Task 1)
- KPI and ratio calculations (Tasks 2 & 3)
- PowerPoint Draft or Outline (Task 6) upload as .pptx outline.
2. Interpret Manufacturing KPIs
- Choose three KPIs common to manufacturers (e.g., gross margin %, inventory turnover, operating cash-flow ratio).
- Calculate the last reported figure and one peer benchmark.
- Explain what each KPI reveals about efficiency, profitability, or liquidity.
3. Screen an M&A Target with Ratio Analysis
- Identify one publicly traded U.S. manufacturing company that could be acquired.
- Using its public filings, compute at least five core ratios (liquidity, leverage, profitability).
- Conclude whether the target is financially sound and strategically complementary.
4. Propose Strategic Alternatives
- Based on public data and industry trends, outline two growth / sustainability strategies (e.g., reshoring, product diversification, green manufacturing).
- Discuss qualitative fit and approximate financial impact (use rough order-of-magnitude estimates onlyno proprietary data).
5. Analyze Stock Buyback Activity
- Summarize buybacks disclosed in the last three fiscal years (shares repurchased, dollars spent, timing).
- Discuss motives (EPS management, capital-structure optimization, signaling) and quantify effects on EPS and leverage.
6. Communicate Results to Stakeholders
- Prepare a concise, one-page financial brief that highlights:
-
- Revenue and earnings trends
- Cash-flow health
- Balance-sheet strength/risk
- Draft a PowerPoint outline (68 bullets and slide titles) that you would use to brief senior management or investors Emphasize clarity, plain language, and actionable insights.
Requirements: As long as it needs to be to satisfy requirements
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
✔Secure Service ✔ Plagiarism Free ✔On-time Delivery
Leave a Reply
You must be logged in to post a comment.