The company has within recent years been experiencing increases in revenues from its construction related services such as design, build, expansion and remodeling, and emergency services. It’s main line of business is from the construction of roads and commercial buildings within Jamaica and to a lesser extent a few other Caribbean countries. Since the growth of the tourism sector in the Caribbean, BnB Caribbean has become concerned about the number of other construction companies which have entered the market to provide similar services around the Caribbean region. Business overseas contributes to 40% of the company’s revenues, while the other 60% comes mainly from works done in the domestic market. The COVID-19 pandemic has caused a slowdown in overall operations leading to prolonged delays in delivery of raw materials from abroad. The CEO of the company is optimistic that there will be a turnaround in operations in 2021, and is therefore considering contracting a loan of $500.0 Million from its local bank to help rebuild its lead position in the market and to expand its line of business to include the sales of heavy equipment. The company has over the years relied mainly on issuing long-term bonds to finance its capital projects. As of today, the firm has 50.0 million shares of common stock outstanding. You are hired as the Chief Financial Controller of the company to advise the CEO and board of the company of the current financial health of the company and to assist them in determining whether they would be successful with the new loan. You began by gathering the following financial statements and other data about the firm. (image attached) Required: What is the Analysis of Financial Data (image attached)
The company has within recent years been experiencing increases in revenues from its construction related services such as design, build, expansion and remodeling, and emergency services. It’s main line of business is from the construction of roads and commercial buildings within Jamaica and to a lesser extent a few other Caribbean countries. Since the growth of the tourism sector in the Caribbean, BnB Caribbean has become concerned about the number of other construction companies which have entered the market to provide similar services around the Caribbean region. Business overseas contributes to 40% of the company’s revenues, while the other 60% comes mainly from works done in the domestic market.
The COVID-19 pandemic has caused a slowdown in overall operations leading to prolonged delays in delivery of raw materials from abroad. The CEO of the company is optimistic that there will be a turnaround in operations in 2021, and is therefore considering contracting a loan of $500.0 Million from its local bank to help rebuild its lead position in the market and to expand its line of business to include the sales of heavy equipment. The company has over the years relied mainly on issuing long-term bonds to finance its capital projects. As of today, the firm has 50.0 million shares of common stock outstanding. You are hired as the Chief Financial Controller of the company to advise the CEO and board of the company of the current financial health of the company and to assist them in determining whether they would be successful with the new loan.
You began by gathering the following financial statements and other data about the firm. (image attached)
Required:
What is the Analysis of Financial Data (image attached)
![SUGGESTED FORMAT FOR REPORT
1. Analysis of Financial Data (Table with ratios)
2021
Industry
Ratio Analysis
Est.
2020
2019
Average
Liquidity Ratios
Current Ratio (times)
4. 2
Quick Ratio (times)
2.1
Asset Management Ratios
Average sales/day
9.
Inventory Turnover Ratio (times)
9
Days Sales Outstanding (days)
36
Fixed Assets Turnover Ratio (times)
Total Asset Turnover Ratio
1.8
Debt Management Ratios
Total Debt to Total Assets (%)
40
Times Interest Earned (times)
6.
Debt to Equity Ratio (%)
Profitability Ratios
Profit Margin on Sales (%)
8
Earning Power (%)
17.2
Return on Total Assets (%)
12
Return on Common Equity (%)
25
Market Value Ratios Price/Earnings Ratio
Price/Earnings Ratio (times)
12.5
Price/Cash Flow Ratio (times)
6. 8
Market /Book Value Ratio (times)
1.7](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F86f2537f-9d29-4c47-890a-b5c900cb85d5%2F06c9fb22-89c3-4f22-a8a5-5ff43042ccd1%2Fsuh6dzq_processed.png&w=3840&q=75)
![BnB Construction Inc.
Income Statement (Millions of Dollars)
BnB Construction Inc.
Balance Sheet (Millions of Dollars)
2021 Est.
2020
2019
Net Sales
4,000
3,000
2,850
2021
2021
Assets
2020
2019
Liabilities
2020
2019
Est
Est
Operating Costs
3,100
2,300
2,100
EBITD
900.00
700
750
Cash and Cash
15
10
15
Accounts payable
115
60
30
Depreciation
110
100
90
Equivalents
Amertizaton
Depreciation and Amortization
Short-Term
Overdrafts
115
110
60
investments
110
100
90
EBITD
790
600
660
Accounts Receivable
420
375
315
Аccruals
260
140
130
Interest
100
88
60
Inventories
700
615
415
Total Current Liabilities
490
310
220
Earnings Before Taxes
690
512
600
Long-Term Bonds and
Total Current Assets
1,145
1,000
Taxes (40%)
276
204.8
240
810
1300
754
580
New Loan
Net Income Before preferred Dividends
414
307.2
360
Net Plant and
1884
1,190
Preferred Dividends
4
4
4
870
Total Debt
1790
1,064.00
800
Equipment
Net Income
410.0
303.2
356.0
Preferred Stock
40
40
40
Common Dividends
57.5
57.5
53
Common Stock
130
130
130
Addition to retained Earnings
352.50
245.70
303.0
Retained Earnings
1069
956
710
Total Common Equity
1199
1086
840
Total Liabilities and
$
Total Assets
Per Share Date
2021
2020
2019
3,029
2,190
1,680
Equity
3,029
2,190
1,680
Common Stock Price
28.0 $
23.00
26.00
Earnings Per Share (EPS)
Dividend Per Share (DPS)
Book Value Per Share (BVPS)
???
6.06 $
7.12
Est. Estimate
????
1.15 $
1.06
????
21.72
16.80
Cash Flow Per Share
????
8.06 S
8.92](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F86f2537f-9d29-4c47-890a-b5c900cb85d5%2F06c9fb22-89c3-4f22-a8a5-5ff43042ccd1%2Fsm6iw9_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)