Canelo Partners Work Sample Instructions

pdf

School

University of South Florida *

*We aren’t endorsed by this school

Course

6935

Subject

Finance

Date

Feb 20, 2024

Type

pdf

Pages

1

Uploaded by EarlHeatLyrebird30

Report
Instructions 1. Please open the Three-Statement Financial Model (Excel file attached), and complete all the requested information (in yellow). We have provided the following information: a. Four years of historical Income Statements (lines 11 to 30) b. One year of the Projected Income Statement 1 c. Three years of Balance Sheet Statements 2 d. Working Capital and CapEx schedule 3 Use your best judgment to make projections. If you need to make assumptions, please state them clearly. 2. Based on the results, please answer the following questions in no more than one page (can be submitted on word or PDF format). a. Revenue Growth - What was your rationale to build the revenue projections from 2025E to 2028E? How do they relate to the company’s historical performance? b. Customer Base - Do you believe the company has a healthy customer base? Why? c. Revenue Quality - How would the following business model impact the company’s growth potential? (i) transactional sales (e.g. clothing), (ii) subscription-based sales (e.g. streaming services), (iii) annual contracts, and (iv) three year contracts. Why? d. Financials - How would you describe the financial performance of this company? Why? Please refer to specific characteristics and metrics from the Excel file. e. Services - Would your opinion about the company’s financial attractiveness change if you knew it sold pure services (e.g. equipment rental) or software (e.g. subscription-based SaaS)? How? Why? You have 7 days to submit your answers. Once completed, please email both files ( model and writeup ) back to us by 8:00pm EST this day next week . We’ll review the work sample and schedule interviews with the best candidates. Please don’t spend more than 3 hours on this exercise. Also, please don’t share the assessment nor model with any other candidates. Thank you, and good luck! - on behalf of CANELO PARTNERS 3 This should enable you to create the balance sheet projections. Pay attention to the PP&E, Cash, and Retained Earnings lines. 2 This should enable you to create the historical Cash Flow Statement and projected Cash Flow Statement. 1 The projected FY24 (column J) should give you enough insights to complete the Income Statement projections from 2025 to 2028. Note that lines 78 to 93 include some KPIs which can be used to guide your projections
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help