Canelo Partners Work Sample Instructions
pdf
keyboard_arrow_up
School
University of South Florida *
*We aren’t endorsed by this school
Course
6935
Subject
Finance
Date
Feb 20, 2024
Type
Pages
1
Uploaded by EarlHeatLyrebird30
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
Related Documents
Related Questions
Balance Sheet. Use Table 3.2 on page 82 as a guide to create a monthly balance sheet
arrow_forward
Pls answer the all questions with solutions. Thank you
arrow_forward
Question 1
Mabel is a potter and sells her pottery at stalls that she rents in four tourist information centres
across the south of England.
Extracts from her financial statements for the years ended 31 December 2021 and 2020 are
shown below.
Statement of profit or loss for the year ended 31 December:
2021
28,900
|(16,500)
12,400
(3,800)
8,600
|(4,000)
4,600
2020
Revenue
27,200
(14,000)
13,200
(3,600)
9,600
Cost of sales
Gross profit
Operating expenses
Operating profit
Non-operating expenses
Net profit
9,600
Statement of financial position as at 31 December:
2021
Non-current assets
Current assets
Total assets
22,660
4,360
27,020
2020
20,920
3,750
24,670
Equity
Non-current liabilities
Current liabilities
Equity and liabilities
20,940
3,000
3,080
27,020
16,340
3,500
4,830
24,670
The following information is also relevant:
In July 2021 the rent on one of Mabel's stalls was increased significantly for the third time in
three years so she decided not to renew the annual contract. She sold…
arrow_forward
The image uploaded is the calculation of Socite Generale Bank, Ghana, Profitability ratios, shorter liquidity ratios, long-term liquidity ratios, and investment ratios for 2020, 2021, 2022. A base year of 2019 was also added. Evaluate the financial performance by comparing the three (3) years' financial performance that is 2020, 2021, and 2022 I have provided in the table with the base year.
arrow_forward
As thorough of an explanation as possible please. I need the answer but also want to learn as well. Thank you.
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Question 1
Please refer to the instructions and the table in this question. Enter the correct journal entry for part [A] in the following Balance Sheet and Income Statement for 20X2. Note that for the purpose of preparing the Balance Sheet at the end of each year:
For investments, you need to classify whether they are current assets (i.e., short-term investment) or non-current assets (i.e., long-term investment);
For bonds, you need to determine what portion of the bonds payable is current liability and what portion is non-current liability. Current portion of the bonds payable is the principal payment portion of the cash interest payments in the next year. Non-current portion is the remaining amount of the bonds payable; and
For leases (as the lessee), you need to determine what portion of the lease obligation is current liability and what portion is non-current liability. Current portion of the lease obligation is the principal payment portion of the cash lease payment in…
arrow_forward
Please I need fast answer please use math tools and no plagiarism i request plz
arrow_forward
Please only by financial calculator give steps and if possible output picture also
arrow_forward
I need help figuring:
G. operating profit margin
H. Long-term debt ratio (use end of year balance sheet figure)
I. Total debt ratio (use end of your balance sheet figures)
J. Times interest earn
K. Cash coverage ratio
L. Current ratio (use end of your balance sheet figures)
M. Quick ratio (use end of your balance sheet figures)
arrow_forward
Hello, how do I solve this problem?
I attached the bottom part of the question and what it's asking for since it wouldn't fit in the screenshot.
Assuming that total assets were $3,112,000 at the beginning of the current fiscal year, determine the following. When required, round to one decimal place.
a. Ratio of fixed assets to long-term liabilities
b. Ratio of liabilities to stockholders' equity
c. Asset turnover
d. Return on total assets
%
e. Return on stockholders’ equity
%
f. Return on common stockholders' equity
%
arrow_forward
Please answer both a and b thx
arrow_forward
Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3.
Complete this question by entering your answers in the tabs below.
Analysis Analysis
Bal Sheet Inc Stmt
Prepare a vertical analysis of the balance sheets for Year 4 and Year 3. (Percentages may not
add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be
entered as 23.45).)
Assets
Current assets
Cash
Marketable securities
Accounts receivable (net)
Inventories
Prepaid items
Total current assets
Investments
RUNDLE COMPANY
Vertical Analysis of Balance Sheets
Year 4
Plant (net)
Land
Total long-term assets
Total assets
Liabilities and stockholders' equity
Liabilities
Current liabilities
Notes payable
Accounts payable
Salaries payable
Total current liabilities.
Noncurrent liabilities
Bonds payable
Other
Total noncurrent liabilities
Total liabilities
Stockholders' equity
Preferred stock (par value $10, 4%
cumulative, nonparticipating; 7,200
shares authorized…
arrow_forward
For an accessible version, see the Excel spreadsheet.
Locate the formula in the textbook and calculate the 2022 Current Ratio (Liquidity). Fill in the numerator and denominator using the
financial statements provided (no symbols or commas) and the answer should be in a XX.XX % format: Blank 1; ÷ Blank 2; = Blank
3%
Blank 1
Blank 2
Blank 3
Add your answer
https://multimedia.phoenix.edu/cms/202337987
Add your answer
Add your answer
arrow_forward
Please answer complete and properly
arrow_forward
17) Based on the balance sheet given for Just Dew It, calculate the following financial ratios for each year:
current ratio
quick ration
cash ratio
NWC to total assets ratio
debt-equity ratio and equity multiplier
Total debt ratio and long-term debt ration
arrow_forward
=
The current year financial statements for Blue Water Company and Prime Fish Company are presented below.
Prime Fish
Balance sheet
Cash
Accounts receivable (net)
Inventory
Property & equipment (net)
Other assets
Total assets
Current liabilities
Long-term debt (interest rate: 15%)
Capital stock ($10 par value)
Additional paid-in capital
Retained earnings
Total liabilities and stockholders' equity
Income statement
Sales revenue (1/2 on credit)
Cost of goods sold
Operating expenses
Net income
Other data
Per share stock price at end of current year
Blue Water
$ 42,300
44,500
92,500
159,500
85,300
$ 424,100
$ 92,500
74,100
157,100
30,300
70,100
$ 424,100
$ 427,500
(234,500)
(163,600)
$ 29,400
$ 23.3
45%
$ 19,700
34,900
47,800
416,600
318,000
$ 34,300
$ 837,000
$ 68,500
62,600
525,000
107,300
73,600
$ 837,000
$ 789,000
(401,300)
(312,300)
$ 75,400
$28
45%
Average income tax rate
Dividends declared and paid in current year
Both companies are in the fish catching and manufacturing business.…
arrow_forward
Hello, I need help
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Need help please. Thank you
arrow_forward
Refer to the 10-K for Abercrombie & Fitch.
Required:
1. What does the company report for the following accounts for the most current fiscal year:
Enter your answer in thousands.
a. Cash
b. Short-term investments (or marketable securities)
c. Accounts receivable
d. Inventory
e. Other current assets
f. Accounts payable
g. Other current liabilities
h. Cash flow from operations
A
A
AA
A
A
好
2. The company projects the following to occur in the next fiscal year:
• Accounts payable will decrease by 25%.
• Other current liabilities are expected to increase by 33%.
• Cash flow from operations is expected to decrease by 32%.
Assume all other items remain unchanged from the prior year.
Provide the next year's forecasted balances for the following accounts and cash flow from operations.
arrow_forward
Balance Sheet
Prepare a vertical analysis of the balance sheets for Year 4 and Year 3.
Note: Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (L.e., .2345 should be entered
as 23.45).
Assats
Current assets
Cash
Income
Statement
Marketable securities
Accounts receivable (net)
Inventories
Prepaid Items
Total current assets
Investments
Plant (net)
Land
Total long-term assets
Total assets
Liabilities and stockholders' equity
Liabilities
Current liabilities
Notes payable
Accounts payable
Salaries payable
Total current liabilities
Noncurrent liabilities
Bonds payable
Other
FANNING COMPANY
Vertical Analysis of Balance Sheeta
Year 4
Total noncurrent liabilales
Total abilities
Stockholders' equity
Preferred stock (par value $10, 4% cumulative,
nonparticipating: 6,600 shares authorized and issued)
Common stock (no par; 50,000 shares authorized;
10,000 shares issued)
Retained earnings
Total stockholders' equity
Total liabilities and stockholders' equity…
arrow_forward
Which of the following statements are true?
Vertical Analysis is also termed as trend analysis.
When all the figures in a balance sheet are stated as percentage of the total, it is termed as horizontal analysis.
When financial statements of several years are analyzed, it is termed as vertical analysis.
O Horizontal analysis is also known as trend analysis.
arrow_forward
use the following information to construct a balance sheet:
current assets $1,000; current liabilities $850; fixed assets $4,500; long term debt $1,000.
what is the value of equity
arrow_forward
Please correct Solution with Explanation and do not give image format
arrow_forward
Guys could you please help me: I'm attaching AT&T's Balance Sheet and Income Statement for the analysis.I'd really appreciate help with the following:
Perform a vertical financial analysis incorporatingi. Debt ratioii. Debt to equity ratioiii. Return on assetsiv. Return on equityv. Current ratiovi. Quick ratiovii. Inventory turnoverviii. Days in inventoryix. Accounts receivable turnoverx. Accounts receivable cycle in daysxi. Accounts payable turnoverxii. Accounts payable cycle in daysxiii. Earnings per share (EPS)xiv. Price to earnings ratio (P/E)xv. Cash conversion cycle (CCC), andxvi. Working capitalxvii. Explain Dupont identity, apply it to your selected company, interpret thecomponents in Dupont identity.
arrow_forward
Carter Paint Company has plants in four provinces. Sales last year were $100 million, and the balance sheet at year-end is similar in
percent of sales to that of previous years (and this will continue in the future). All assets and current liabilities will vary directly with
sales. Assume the firm is already using capital assets at full capacity.
Cash
Accounts receivable.
Inventory
Current assets
Capital assets
Assets
Total assets
$9
15
10
34
34
$68
Balance Sheet
(in $ millions)
Liabilities and Shareholders' Equity
Accounts payable
Accrued vages
Accrued taxes
Current liabilities.
Long-term debt
Common stock
Retained earnings
Total liabilities and shareholders' equity
$9
8
7
24
10
15
19
$68
The firm has an aftertax profit margin of 8 percent and a dividend payout ratio of 40 percent.
a. If sales grow by 20 percent next year, determine how many dollars of new funds are needed to finance the expansion. (Do not
round intermediate calculations. Enter the answer in millions. Round the final…
arrow_forward
Calculate the Current Ratio, Debt Ratio, Return on Assets (ROA) and Return on Equity (ROE). For the ROA and ROE, you should use the average total assets and the average total equity in your calculations. (The average is the total across two years divided by two). Calculate these values for each of 2011-2014. Interpret your calculations: what does this information mean? How is the company doing?
arrow_forward
dont uplode any image in answer
arrow_forward
Chapter 5, page 344 and 349:
EA12. 5.3 Using the following Balance Sheet summary information, calculate for the two years
presented:
A. working capital
B. current ratio
12/31/2018
12/31/2019
$76,000
48,000
Current assets
$295,000
Current liabilities
163,500
After computing liquidity ratios, comment on the performance of an entity using acceptable standards
of liquidity performance
arrow_forward
Required:
Match each term with its related definition by selecting the appropriate letter from the definition list that follows. There should be only
one definition per term (that is, there are more definitions than terms).
Definition
A. Economic resources to be used or turned into cash within one year.
B. Reports assets, liabilities, and stockholders' equity.
C. Decrease assets; increase liabilities and stockholders' equity.
D. Increase assets; decrease liabilities and stockholders' equity.
E. An exchange or event that has a direct and measurable financial effect.
F. Accounts for a business separate from its owners.
G. The principle that assets should be recorded at their original cost to the company.
H. A standardized format used to accumulate data about each item reported on financial statements.
I. The basic accounting equation.
J. The idea that accounts can both increase and decrease.
K. The account credited when money is borrowed from a bank using a promissory note.
L. Cumulative…
arrow_forward
provide correct answer me?
arrow_forward
compute the following ratios using the Balance Sheet (Current Year) and Income Statement provided in the images below
Current Ratio (in numeric format, 2 decimal places):
Debt to Equity (in numeric format, 2 decimal places():
Return on Equity (stated as a percentage, 2 decimal places):
Return on Assets (stated as a percentage, 2 decimal places):
arrow_forward
Please answer 4 & 5
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Related Questions
- Balance Sheet. Use Table 3.2 on page 82 as a guide to create a monthly balance sheetarrow_forwardPls answer the all questions with solutions. Thank youarrow_forwardQuestion 1 Mabel is a potter and sells her pottery at stalls that she rents in four tourist information centres across the south of England. Extracts from her financial statements for the years ended 31 December 2021 and 2020 are shown below. Statement of profit or loss for the year ended 31 December: 2021 28,900 |(16,500) 12,400 (3,800) 8,600 |(4,000) 4,600 2020 Revenue 27,200 (14,000) 13,200 (3,600) 9,600 Cost of sales Gross profit Operating expenses Operating profit Non-operating expenses Net profit 9,600 Statement of financial position as at 31 December: 2021 Non-current assets Current assets Total assets 22,660 4,360 27,020 2020 20,920 3,750 24,670 Equity Non-current liabilities Current liabilities Equity and liabilities 20,940 3,000 3,080 27,020 16,340 3,500 4,830 24,670 The following information is also relevant: In July 2021 the rent on one of Mabel's stalls was increased significantly for the third time in three years so she decided not to renew the annual contract. She sold…arrow_forward
- The image uploaded is the calculation of Socite Generale Bank, Ghana, Profitability ratios, shorter liquidity ratios, long-term liquidity ratios, and investment ratios for 2020, 2021, 2022. A base year of 2019 was also added. Evaluate the financial performance by comparing the three (3) years' financial performance that is 2020, 2021, and 2022 I have provided in the table with the base year.arrow_forwardAs thorough of an explanation as possible please. I need the answer but also want to learn as well. Thank you.arrow_forwardhelp please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forward
- Question 1 Please refer to the instructions and the table in this question. Enter the correct journal entry for part [A] in the following Balance Sheet and Income Statement for 20X2. Note that for the purpose of preparing the Balance Sheet at the end of each year: For investments, you need to classify whether they are current assets (i.e., short-term investment) or non-current assets (i.e., long-term investment); For bonds, you need to determine what portion of the bonds payable is current liability and what portion is non-current liability. Current portion of the bonds payable is the principal payment portion of the cash interest payments in the next year. Non-current portion is the remaining amount of the bonds payable; and For leases (as the lessee), you need to determine what portion of the lease obligation is current liability and what portion is non-current liability. Current portion of the lease obligation is the principal payment portion of the cash lease payment in…arrow_forwardPlease I need fast answer please use math tools and no plagiarism i request plzarrow_forwardPlease only by financial calculator give steps and if possible output picture alsoarrow_forward
- I need help figuring: G. operating profit margin H. Long-term debt ratio (use end of year balance sheet figure) I. Total debt ratio (use end of your balance sheet figures) J. Times interest earn K. Cash coverage ratio L. Current ratio (use end of your balance sheet figures) M. Quick ratio (use end of your balance sheet figures)arrow_forwardHello, how do I solve this problem? I attached the bottom part of the question and what it's asking for since it wouldn't fit in the screenshot. Assuming that total assets were $3,112,000 at the beginning of the current fiscal year, determine the following. When required, round to one decimal place. a. Ratio of fixed assets to long-term liabilities b. Ratio of liabilities to stockholders' equity c. Asset turnover d. Return on total assets % e. Return on stockholders’ equity % f. Return on common stockholders' equity %arrow_forwardPlease answer both a and b thxarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning