Peak Roofing financials

xlsx

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

Report
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