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)

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

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
Transcribed Image Text: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
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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Industry Specific Activities
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education