Posted: November 1st, 2022
FNCE 3140 Assignment Fall 2022
FNCE 3140 Assignment Fall 2022
Professor Cox
Terrace Corporation is a machine maker in Interior British Columbia established in 1995. It has grown over time by making high quality machines and providing excellent customer service. The production plant is located in Merritt and is operating near 100% capacity. Sales are concentrated with 1 large customer, Victoria Vagabonds, under accounts receivable terms of net 50. Raw materials are purchased from a Salmon Arm distributor under terms of net 60 with overdue accounts paying 9% per annum. Financing is from various sources one of which is RBC under a 2 year term revolving line of credit of $6 million. Security for this financing is pledging inventory and accounts receivable as well as a $3 million personal guarantee by the owner-CEO Charlotte Vavavoom. RBC will lend up to 80% of accounts receivable, 35% of raw materials, 20% of work-in-process and 40% of finished goods inventory. The revolving line of credit must have a zero balance for at least 1 month of the year. Covenants with the loan include maintaining a current ratio of 1.7, cash flow coverage of 1.6 and a long-term debt to total capitalization ratio no more than 55%. No dividends are paid and all profits are reinvested in the company for growth. RBC is concerned that Terrace is floundering financially speaking and is reviewing its performance over the last 4 years.
RBC will lend up to 80% of receivables, 35% of raw materials, 20% of work-in-process inventory, and 40% of finished goods inventory. For at least one month of the year, the revolving line of credit must have a zero balance. The loan requires a current ratio of 1.7, cash flow coverage of 1.6, and a long-term debt to total capitalization ratio of no more than 55%. There are no dividends paid, and all profits are reinvested in the company for future growth. Terrace is struggling financially, and RBC is reviewing its performance over the last four years.
Conduct a thorough financial analysis based on the 5 years of income statements and balance sheets provided as well as industry average benchmarks. Include in your report ratio analysis, common size analysis (horizontal and vertical) for 2017-2021 as well as cash flow statements for 2017-2021 plus an annual DuPont Identity ROE analysis. Your report should include a 2 page summary of your analysis.
Note:
1. Cash flow coverage is defined as (EBIT + Depreciation)/Interest)
2. Cash ratio = Cash/(Current liabilities)
3. Long-term debt to capitalization ration = LTD/(LTD + Total Equity)
4. ROA = (Net Income)/(Total Assets)
5. Turnover ratios use end-of-period account balances, i.e. no averaging
Who Can Write My Dissertation or Research Paper? Best Writing Service!
Looking for reliable dissertation help or thesis writing? Our expert team of MPhil and PhD-qualified professionals provides top-notch online assistance for dissertations, research papers, and essays—free from errors, plagiarism, and hidden fees. We select each specialist based on their academic expertise, ensuring high-quality thesis writing and research paper support. Beyond writing, we offer personalized guidance, one-on-one doubt-clearing sessions, and free study resources. Whether you need instant dissertation help or long-term research paper support, our experts are ready to help you succeed.
Terrace Corp. Income Statements in $ for 2017 to 2021
Sales 45046500 78391680 1.1820996E+08 1.7559702E+08 2.1453516E+08
COGS 31303500 55786590 84969180 127696980 159000450
GP 13743000 22605090 33240780 47900040 55534710
S & D 4951020 7351890 11290200 16201050 18003690
R&D 436020 1360920 2296020 4741020 5701350
Admin 1651020 3152250 5851800 10200000 12241560
Amort 1739832 2726652 5640852 8997597 11516370
Operating Profit 4980108 8013378 8161908 7760373 8071740
Interest 672417 1178277 2856924 4959705 6903528
EBT 4307691 6835101 5304984 2800668 1168212
Taxes 1507692 2392287 1856745 974235 408873
Net Income 2799999 4442817 3448239 1826433 759336
Terrace Corp. Balance Sheets in $ for 2017 to 2021
Cash 1202250 2372010 3104070 2470740 2296020
A/R 7378800 13021620 19351020 29851020 34651260
RM Inv 2026020 3310200 5368020 7351020 9721020
WIP Inv 2622960 4321590 5851020 7022040 7468170
F/G Inv 2406480 5022879 7843749 13241259 20255139
CA 15636510 28048299 41517879 59936079 74391609
L,P,E net 16513320 26269020 55036020 88360050 113068680
Intang 735000 997500 1372500 1615920 2095020
T Assets 32884830 55314819 97926399 149912049 189555309
0 0 0 0 0
A/P 5281020 12029610 19494681 29768988 38656326
CPLTD 1198602 1947564 4556499 7910217 10637178
CL 6479622 13977174 24051180 37679205 49293504
LTD 11986020 19475640 45564978 79102167 106371789
Equity 14419188 21862005 28310244 33130677 33890013
TL & E 32884830 55314819 97926399 149912049 189555309
Benchmark Common Size % Balance Sheet (assume the same for all years)
What Are Custom Dissertation and Thesis Writing Services? Just Essays?
Our custom dissertation help and thesis writing services meet your unique requirements. Unlike companies using pre-written content, we craft every dissertation, research paper, or essay from scratch based on your specific instructions and grading rubric. A subject-specialized writer will deliver a well-researched dissertation or thesis tailored just for you. Beyond essays, our academics and scholars offer PowerPoint presentations, cover letters, editing, tutoring, and business reports—comprehensive dissertation help and research paper support for all your academic needs.
Cash 15.45
A/R 9.34
RM Inv 6.38
WIP Inv 2.54
F/G Inv 13.34
CA 47.05
L,P,E net 43.65
Intang 9.3
T Assets 100
A/P 9.45
CPLTD 5.39
CL 14.84
LTD 33.45
Equity 51.71
TL & E 100
Can I Hire Someone for Dissertation Help or Thesis Writing to Score Top Grades?
Completing dissertations or research papers can be overwhelming, but expert dissertation help and thesis writing are smart ways to improve your grades. Our platform connects you with top-rated tutors in education, law, and nursing, offering high-quality research paper support and sample resources. Working with experienced professionals enhances your dissertation or thesis writing, boosting confidence in your coursework—at affordable fees. Sign up today for instant dissertation help, research paper guidance, and stress-free learning!
Benchmark Common Size Income Statement % (assume the same for all years)
Sales 100
COGS 55
GP 45
S & D 13.45
R&D 1.56
Admin 6.67
Amort 4.77
Operating Profit 18.55
Interest 2.59
EBT 15.96
Taxes 4.79
Net Income 11.17
Benchmarks for Financial Ratios (assume the same for all years 2017 to 2021)
Current 2.7
Cash 0.21
RM turnover (days) 32
WP turnover (days) 14
FG turnover (days) 60
A/R turnover (days) 45
A/P turnover (days) 55
Cash conversion cycle (days) 90
Fixed Assets turnover 2.7X
Total Asset turnover 1.2X
Long-term debt to total capitalization 35%
Cash flow coverage 2X
Gross profit margin 42%
Operating profit margin 16%
Net profit margin 9%
ROA 7%
ROE 15%