Limited Offer Get 25% off — use code BESTW25
No AI No Plagiarism On-Time Delivery Free Revisions
Claim Now
Prices start at $5 per page · plagiarism-free papers · free revisions for 14 days 24/7 support: support@bestwriters.com
Uncategorized

impact of key quantitative and qualitative data

  • Posted
  • Authoradmin
  • Length190 words
  • Reading time1 min
Write My Assignment FREE

Question1 Forecasting EBIT (9 marks | Word limit: 200 words)

LO3: Assess the impact of key quantitative and qualitative data on industrial equity stocks.

LO5: Construct a basic financial model of a company.

This question requires you to build P&L sections of a financial model, using the Excel template provided (‘No Acquisition’ worksheet).

(a) Derive sales forecasts for The Reject Shop for the next two (2) years.

The sales forecast module of the model is provided in the ‘Store analysis’ section of the spreadsheet. You are required to provide assumptions for new store growth and also the expected increase or decrease in sales in order to forecast sales figures for the next two years. (4 marks)

(b) Derive EBITDA margin forecasts for the company for the next two (2) years. Explain how you derived your forecasts with reference to applicable company announcements. (2 marks)

(c) Derive forecasts for amortisation and depreciation and, subsequently, forecast EBIT for the next two (2) years. Explain how you derived your forecasts with reference to applicable company announcements. (3 marks)

The post impact of key quantitative and qualitative data appeared first on My Assignment Online.

Plagiarism Free Assignment Help

Expert Help With This Assignment — On Your Terms

✓ Native UK, USA & Australia writers ✓ Deadline from 3 hours ✓ 100% Plagiarism-Free — Turnitin included ✓ Unlimited free revisions ✓ Free to submit — compare quotes

admin

Academic writer and editor at BestWriters.

Get your paper off your plate tonight

Post your instructions for free. Prices start at $5 per page.

Place an order