Peak Roofing financials
xlsx
keyboard_arrow_up
School
University of North Texas *
*We aren’t endorsed by this school
Course
MISC
Subject
Finance
Date
Jan 9, 2024
Type
xlsx
Pages
8
Uploaded by NicholasBarnsley9
Size Up
Internal
offer everything and anything to do with roofing
Small size company
Quality service
knowledgeable staff
Double diget growth over the last 15 yrs
No formal inventory management system - maintained inventory levels consistent with his beliefs
Ordered large amounts of supplies to take advantage of bulk discounts - maintain profit margins
Refused to take on debt unless it was absolutely necessary
External
Big Box stores to not significantly influence business
Has more value than the competitors
doesn’t compete for large roofing contracts on new commercial dev
Rapid expansion of the montreal market
Re-roofing less cyclical than the new housing market
GDP in Canada had grown 4.5% in 1999, 3.3% from 1998
unemployment rates at a record low
High competition in the building supplies industry
Customers willing to pay more for better service in the renovations part of the industry
Increase spending on residential renos in 1999 and 2000
Role
: Gerry Dillabaugh
Decision
: grant a loan to Peak to finance an expansion by adding a new site in south of montreal
Exhibit 3
Balance Sheet
For the years ended December 31
Actual
1991
1992
1993
1994
1995
1996
1997
1998
ASSETS:
Cash
$
2 $
2 $
1 $
4 $
1 $
4 $
34 $
22
Accounts Receivable - Trade
486
839
926
1,193
1,329
1,977
2,110
2,107
Inventory
1,986
1,836
1,936
2,438
2,827
2,803
3,403
3,678
Prepaid Expenses
45
62
47
80
81
104
3
10
Total Current
2,519
2,739
2,910
3,715
4,238
4,888
5,550
5,817
Fixed Assets
Plant and Equipment
1,882
2,004
2,256
2,482
3,893
4,035
4,503
5,317
Land
480
480
480
480
1,005
1,005
1,005
1,005
Gross Fixed Assets
2,362
2,484
2,736
2,962
4,898
5,040
5,508
6,322
less: Accumulated Depreciation
851
1,058
1,284
1,528
1,880
2,239
2,638
3,074
Net Fixed Assets
1,511
1,426
1,452
1,434
3,018
2,801
2,870
3,248
TOTAL ASSETS
$
4,030 $
4,165 $
4,362 $
5,149 $
7,256 $
7,689 $
8,420 $
9,065
LIABILITIES
Operating Loan
$
1,177 $
742 $
524 $
820 $
1,659 $
1,221 $
2,498 $
2,479
Current Maturities - Long Term Debt
-
-
-
-
95
90
121
91
Accounts Payable
342
784
1,066
1,342
905
1,767
1,053
1,171
Income Taxes Payable
-
1
-
70
49
47
45
44
Total Current
1,519
1,527
1,590
2,232
2,708
3,125
3,717
3,785
Long Term Debt
230
230
230
230
1,759
1,675
1,711
2,245
Deferred Income Taxes
68
45
41
15
6
7
4
-
Total Liabilities
1,817
1,802
1,861
2,477
4,473
4,807
5,432
6,030
Net Worth
2,213
2,363
2,501
2,672
2,783
2,882
2,988
3,035
TOTAL LIABILITIES & NET WORTH
$
4,030 $
4,165 $
4,362 $
5,149 $
7,256 $
7,689 $
8,420 $
9,065
2000
2001
AR
1,850
2487
Daily Sales
66.30137 89.138508
Days of A/R
27.90
27.902893
Projected A/R
2,487.22
2984.6667
Inv
5,100
6,856.67
Daily COGS
52.054795 69.984779
Days of Inv
97.97
97.97
Projected Inv
6,856.67
8,228.00
AP
2,480
Daily Purchases
55.950685
Days of AP
44.32
Projected AP
3,102.06
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Estimated
1999
2000
2001
Assumptions
$
25 $
34 $
34
Per Store $ = 8500 per store
1,850
2,487.22
2984.666667
5,100
6,856.67
8,228.00
10
13.33
13.33
Divide by 3 then multiply by 4
6,985
9,391
11,260
5,535
7,457
7,904.53
1,005
1,505
1,505.00
6,540
8,962
9,410
3,479
4,225
5,015
3,061
4,737
4,394
$
10,046 $
14,129 $
15,654
$
2,100
Err:522
Err:522 PLUG
Look at trend, if it goes above the max, then would you still give the loan
90
600
600
2,480
3,102.06
3,722.47
44
Err:522
Err:522 ASK ABOUT THIS
4,714
Err:522
Err:522
2,240
4800
4200 GET AT BEGINNING OF YEAR SO SUBSTRACT 2X
-
6,954
Err:522
Err:522
3,092
Err:522
Err:522
$
10,046 $
14,129 $
15,654
Exhibit 4
Income Statements ($000)
For the years ended December 31
Actual
Estimated
1991
1992
1993
1994
1995
1996
1997
1998
1999
Sales
$
9,382 $
10,720 $
12,316 $
15,548 $
17,379 $
22,520 $
23,640 $
22,558 $
24,200
New Sales
Total Sales
Cost of Goods Sold
6,902
7,895
9,189
12,008
13,430
17,781
18,787
17,635
19,000
Gross Profit
2,480
2,825
3,127
3,540
3,949
4,739
4,853
4,923
5,200
General & Administrative Expense
1,687
2,166
2,505
2,758
2,902
3,644
3,727
3,737
3,840
Lease & Rental Expense
85
90
90
90
94
94
93
92
91
Depreciation
206
207
226
244
352
359
399
436
405
Total Operating Expenses
1,978
2,463
2,821
3,092
3,348
4,097
4,218
4,265
4,336
Operating Income
502
362
306
448
601
642
635
658
864
Interest Expense
(100)
(101)
(73)
(63)
(300)
(316)
(342)
(422)
(439)
LT Interest X
LOC Interest X
Other Income
145
150
197
231
192
231
256
269
275
Extraordinary Expense
-
-
-
-
-
-
-
-
(190)
Profit Before Tax
547
411
430
616
493
557
549
505
510
Taxes
137
103
95
129
172
28
104
147
117
NET PROFIT
$
410 $
308 $
335 $
487 $
321 $
529 $
445 $
358 $
393
New Venture:
2000000 cost
1,500,000 of new assets, 500,000 of land
Depreciation Calculation:
Amount
Capital Ex
Rate
Total 2000
Total 2001
Existing
5,535
6%
10%
586.71 621.9126
New
1500
6%
10%
159
168.54
Term Loan Calculation:
Ratios
Assets
10000
Current
1.481756
Loan
60%
Quick
0.399873
Term Loan
6000
EBIT/Int
2.1625199
Cost of Funds
6.60%
Funded Debt/
Basis Point
2%
EBITDA
3.49 ASK OF THIS
Total Rate
8.60%
Equity
1.43273
ASK OF THIS
Value
516
Debt/Equity
2.24903
Operating Loan Calc
A/R
75%
1,850
1387.5
Inv
50%
5,100
2550
Prime Rate
6.50%
3937.5
Basis Point
1%
Total Rate
7.50%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Assumtions
2000
2021
Existing
New
26620
29282
10%
5916
9761
32536
39043
25544
30653
79%
6991
8389
5163
6195
16%
122
122
Same $
746
790
10% of BV
6030
7107
961
1282
-516
-464
Err:522
Err:522
292
309
6%
Err:522
Err:522
Err:522
Err:522
23%
Err:522
Err:522
once done calculations, do some sensitivity to talk about diff scenarios
Related Documents
Related Questions
Customer Profitability Analysis: Boston Depot sells office supplies to area corporations and organizations. Tom Delayne, founder and CEO, has been disappointed with the operating results and the profit margin for the last two years. Business forms are mostly a "commodity" business with low profit margins. To increase profit margins and gain competitive advantages, Delayne introduced "Desk-Top Delivery" service. The business seems to be as busy as ever. Yet, the operating income has been declining. To help identify the root cause of declining profits, he decided to analyze the profitability of two of the firm's major customers: Omega International (OI) and City of Albion (CA).According to the customer profitability analysis that Boston Depot conducts regularly, Boston Depot has the same amount of total sales with both OI and CA. However, the firm earns a higher gross margin and gross margin ratio from CA than those from the sales to OI, as demonstrated here:
Customer…
arrow_forward
Restructuring a Segmented Income Statement
Millard Corporation is a wholesale distributor of office products. It purchases office products from manufacturers and distributes them in the West, Central, and East regions. Each of these regions is about the same size and each has its own manager and sales staff.
The company has been experiencing losses for many months. In an effort to improve performance, management has requested that the monthly income statement be segmented by sales region. The company’s first effort at preparing a segmented income statement for May is given below.
The cost of goods sold and shipping expense are both variable. All other costs are fixed.
Required:
1. List any weaknesses that you see in the company’s segmented income statement given above.
2. Explain the basis that is apparently being used to allocate the corporate expenses to the regions. Do you agree with these allocations? Explain.
3. Prepare a new contribution format segmented income statement for May.…
arrow_forward
Closing an Unprofitable Department
Income (loss) from closure $(12,800)
Tipton One-Stop Decorating sells paint and paint supplies, carpet, and wallpaper at a single-store location in suburban Des Moines. Although the company has been very profitable over the years, management has seen a significant decline in wallpaper sales and earnings. Much of this decline is attributable to the Internet and to companies that advertise deeply discounted prices in magazines and offer customers free shipping and toll-free telephone numbers. Recent figures follow:
Paint and Supplies Carpeting Wallpaper
Sales ............... $380,000 $460,000 $140,000
Variable cost..........$228,000 $322,000 $112,000
Fixed costs ... …........56,000 75,000 45,000
Total costs ............$284,000 $397,000 $157,000…
arrow_forward
Closing an Unprofitable Department
1. Income (loss) from closure $(12,800)
Tipton One-Stop Decorating sells paint and paint supplies, carpet, and wallpaper at a single-store location in suburban Des Moines. Although the company has been very profitable over the years, management has seen a significant decline in wallpaper sales and earnings. Much of this decline is attributable to the Internet and to companies that advertise deeply discounted prices in magazines and offer customers free shipping and toll-free telephone numbers. Recent figures follow:
Paint and Supplies Carpeting Wallpaper
Sales ............... $380,000 $460,000 $140,000 Variable cost..........$228,000 $322,000 $112,000
Fixed costs ... 56,000 75,000 45,000
Total costs ......$284,000 $397,000 $157,000
Operating (income…
arrow_forward
Account short answer need
arrow_forward
Need help with Accounting Question
arrow_forward
Do not give solution in image
arrow_forward
working capital and current assets management
PureCart Ltd. is a rapidly growing e-commerce company experiencing fluctuating demand and unpredictable supplier lead times.
This uncertainty poses challenges for managing their working capital effectively.
The following company financial information has been provided to you:
Cost of goods sold (COGS): R120 000
Goods are sold at 20% on cost.
All goods are sold on credit.
All goods are purchased on credit.
There is no opening and closing stock.
Average inventory: R30 000
Accounts receivable: R40 000
Accounts payable: R25 000
Q3)Calculate the cash conversion cycle. Provide all formulas.
arrow_forward
Please do not give solution in image format thanku
arrow_forward
two divisions: Northern and Southern. Individual stores are placed in one or the other divisio
demographic changes in the Northern Division area have led to declining foot traffic and sal
executives have been asking whether the chain should close those stores and focus on the
recent income statement for the Northern Division follows.
Lessing Toy and Hobby
Northern Division
For the Year Ending January 31
($000)
Sales revenue
Costs
Cost of goods sold
Advertising
Administrative salaries
Sales commissions
Rent and occupancy expense
Allocated corporate support
Total costs
Net loss before tax benefit
Tax benefit at 25%
Net loss
$ 12,540
$ 6,520
495
815
1,629
2,063
1,335
$ 12,857
$ (317)
(79.25)
$ (237.75)
The CEO has asked for your thoughts on the decision to close the Northern Division stores. If
the stores closed, neither total corporate support costs nor operations or costs of the Souther
change.
Required:
a. Using the worksheet below, determine which revenues and costs are probably…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Related Questions
- Customer Profitability Analysis: Boston Depot sells office supplies to area corporations and organizations. Tom Delayne, founder and CEO, has been disappointed with the operating results and the profit margin for the last two years. Business forms are mostly a "commodity" business with low profit margins. To increase profit margins and gain competitive advantages, Delayne introduced "Desk-Top Delivery" service. The business seems to be as busy as ever. Yet, the operating income has been declining. To help identify the root cause of declining profits, he decided to analyze the profitability of two of the firm's major customers: Omega International (OI) and City of Albion (CA).According to the customer profitability analysis that Boston Depot conducts regularly, Boston Depot has the same amount of total sales with both OI and CA. However, the firm earns a higher gross margin and gross margin ratio from CA than those from the sales to OI, as demonstrated here: Customer…arrow_forwardRestructuring a Segmented Income Statement Millard Corporation is a wholesale distributor of office products. It purchases office products from manufacturers and distributes them in the West, Central, and East regions. Each of these regions is about the same size and each has its own manager and sales staff. The company has been experiencing losses for many months. In an effort to improve performance, management has requested that the monthly income statement be segmented by sales region. The company’s first effort at preparing a segmented income statement for May is given below. The cost of goods sold and shipping expense are both variable. All other costs are fixed. Required: 1. List any weaknesses that you see in the company’s segmented income statement given above. 2. Explain the basis that is apparently being used to allocate the corporate expenses to the regions. Do you agree with these allocations? Explain. 3. Prepare a new contribution format segmented income statement for May.…arrow_forwardClosing an Unprofitable Department Income (loss) from closure $(12,800) Tipton One-Stop Decorating sells paint and paint supplies, carpet, and wallpaper at a single-store location in suburban Des Moines. Although the company has been very profitable over the years, management has seen a significant decline in wallpaper sales and earnings. Much of this decline is attributable to the Internet and to companies that advertise deeply discounted prices in magazines and offer customers free shipping and toll-free telephone numbers. Recent figures follow: Paint and Supplies Carpeting Wallpaper Sales ............... $380,000 $460,000 $140,000 Variable cost..........$228,000 $322,000 $112,000 Fixed costs ... …........56,000 75,000 45,000 Total costs ............$284,000 $397,000 $157,000…arrow_forward
- Closing an Unprofitable Department 1. Income (loss) from closure $(12,800) Tipton One-Stop Decorating sells paint and paint supplies, carpet, and wallpaper at a single-store location in suburban Des Moines. Although the company has been very profitable over the years, management has seen a significant decline in wallpaper sales and earnings. Much of this decline is attributable to the Internet and to companies that advertise deeply discounted prices in magazines and offer customers free shipping and toll-free telephone numbers. Recent figures follow: Paint and Supplies Carpeting Wallpaper Sales ............... $380,000 $460,000 $140,000 Variable cost..........$228,000 $322,000 $112,000 Fixed costs ... 56,000 75,000 45,000 Total costs ......$284,000 $397,000 $157,000 Operating (income…arrow_forwardAccount short answer needarrow_forwardNeed help with Accounting Questionarrow_forward
- Do not give solution in imagearrow_forwardworking capital and current assets management PureCart Ltd. is a rapidly growing e-commerce company experiencing fluctuating demand and unpredictable supplier lead times. This uncertainty poses challenges for managing their working capital effectively. The following company financial information has been provided to you: Cost of goods sold (COGS): R120 000 Goods are sold at 20% on cost. All goods are sold on credit. All goods are purchased on credit. There is no opening and closing stock. Average inventory: R30 000 Accounts receivable: R40 000 Accounts payable: R25 000 Q3)Calculate the cash conversion cycle. Provide all formulas.arrow_forwardPlease do not give solution in image format thankuarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage