Book All Semester Assignments at 50% OFF! ORDER NOW

Forecasted Statements

The forecasted statements are as follows:-

NMG, Inc.

Net Income statements (in millions)

2024

2023

2022

2021

for the year ending Decmber 31.

Revenue

11429

$10,390

$11,184

$10,771

Cost of Revenue

$6,939

$6,939

$7,261

$7,058

Gross Profit

$4,490

$3,451

$3,923

$3,713

Product Development

$991

$991

$1,026

$1,232

Marketing and Administrative

$453

$453

$562

$606

Depreciation

$520

$520

$559

$539

Amortization of Intangibles

$23

$23

$53

$104

Restructuring and other, net

($22)

($22)

$89

$178

Stock-based compensation

$0

$0

$0

$0

Total Operating Expenses

$1,965

$1,965

$2,289

$2,659

Income from Operations

$2,525

$1,486

$1,634

$1,054

Interest Income

$84

$38

$12

$12

Interest Expense

($224)

($236)

($222)

($222)

Other, net

$25

($18)

($29)

($29)

Other expenses, net

($115)

($216)

($239)

($239)

Income before Income Taxes

$2,410

$1,270

$1,395

$815

(Benefit) provision for income taxes

($640)

$236

$43

$43

Net Income

$3,050

$1,034

$1,352

$772

NMG, Inc.

Consolidated Balance Sheets

(In millions except share and per share data)

2024

2023

2022

2021

as of December 31.

Current Assets

Cash and Cash Equivalents

$2,220

$2,220

$1,853

$2,539

Accounts receivables, net

1070.098

$989

$1,184

$1,199

Inventories

1049.54

$970

$1,053

$982

Other current assets

188.6

$184

$220

$321

Total current assets

4528.238

$4,363

$4,310

$5,041

Property, Equipment and leasehold improvements, net

$1,869

$1,869

$1,792

$1,875

Investment in debt security

$0

$0

$1,275

$0

Goodwill

$1,237

$1,237

$1,237

$1,238

Other intangible assets, net

$111

$111

$188

$281

Deferred income taxes

$1,114

$1,114

$417

$609

Other assets, net

$191

$191

$191

$224

Total Assets

9050.238

$8,885

$9,410

$9,268

Current Liabilities

Accounts payable

1625.9

$1,420

$1,728

$1,626

Accrued employee compensation

173.056

$169

$253

$237

Accrued warranty

91.7735

$91

$112

$113

Current portion of long-term debt

$0

$0

$499

$0

Accrued expenses

587.328

$552

$598

$650

Total current liabilities

1890.7295

$2,232

$3,190

$2,626

Long-term accrued warranty

105.04

$104

$125

$120

Long-term accrued income taxes

4.368

$4

$10

$15

Other non-current liabilities

131.56

$130

$100

$122

Long-term debt less current portion

4295.53

$4,253

$4,320

$5,021

Total Liabilities

6427.2275

$6,723

$7,745

$7,904

Shareholders’ Equity

Ordinary shares-par value $0.0001, 2.6 billion shares

authorized, 1,354,218,154, and 1,340,697,595 shares

issued and outstanding, respectively

Additional paid in capital

$6,545

$6,377

$6,152

Accumulated other comprehensive Income (loss)

($34)

($16)

($17)

Retained Earnings

($4,349)

($4,696)

($4,771)

Total Shareholders' equity

$2,162

$1,665

$1,364

Total liabilities and shareholders' equity

$8,885

$9,410

$9,268

Ratio Analysis Compare and Contrast

The ratio analysis of the company is as follows:-

RATIO ANALYSIS

NMG 2023

Industry Average

CURRENT RATIO

1.954749104

1.98

QUICK RATIO

1.872311828

1.24

INVENTORY TURNOVER (days)

0.103320429

93

INTEREST COVERAGE

-5.38135593

4.26

ASSET TURNOVER (days)

1.169386607

529

RECEIVABLES TURNOVER (days)

0.093358999

58

GROSS MARGIN

33.21462945

32.50%

OPERATING MARGIN

14.30221367

7.30%

PROFIT MARGIN

9.951876805

5%

ROA

0.116375914

3.70%

ROE

0.157983193

6.70%

Debt to equity

1.027196333

1.01

Dividend pay-out ratio

264.704

0.28

Table: Ratio Analysis Calculation

The calculation reflects that the organization has performed well in comparison to the industry. An assessment of a company's liquidity can be carried out to determine whether or not it holds sufficient current assets to pay its immediate financial obligations. Coverage analysis is used to determine whether or not a business is able to meet its financial responsibilities, such as paying its interest, fees, and other expenses, but not its capital obligations. Instead of relying on people's personal experiences or opinions, the examination of financial ratios is founded on quantitative data (Bustani, Khaddafi & Ilham,.2022).. Financial ratios completely avoid discussing a number of important issues that have the ability to have a substantial impact on the path that a company's development will take. For example, it is unable to determine the level of expertise with which they handle the operations of their business. The analysis of financial ratios, despite the fact that it has a great deal of practical value, offers only a fragmentary representation of the bigger picture. When looking at a firm's Current Ratio, it is important to note that if it has decreased, this may be an indication of possible financial trouble or even insolvency inside the organisation. On the other hand, a Current Ratio that is overly high shows that there is an abundance of unused funds, which could potentially lead to a reduction in the company's profitability. This suggests that the assets can be hastened and provide larger profits, which in turn indicates enhanced utilisation of general assets for the development of sales. To put it another way, if the Total Assets Turnover grows, it is possible for the sales volume to also increase, provided that the assets do not change. It can be said that the company has performed well in terms of its working capital cycle, due to which its current and quick ratio is on the higher side (Mosteanu & Faccia, 2020).

Return on Equity seems to be the most appropriate performance indicator to use when analysing the business that is the subject of this inquiry, based on the descriptions that have been provided. The previously conducted research has produced a wide range of results. The investigation of the underlying aspects that are thought to have an effect on the performance of a firm is not only interesting but also important. The liquidity ratios, the debt, the activity, and the profitability are the major aspects that are considered while making forecasts for the latter. suggestive of the cash ratio is the current ratio, suggestive of the leverage ratio is the debt to equity ratio, and indicative of the activity ratio is the total assets turnover ratio (Brigham & Houston, 2021). 

 

Calculation of Case Assignment

NMG, Inc.        
Net Income statements (in millions) 2024 2023 2022 2021
for the year ending Decmber 31.        
Revenue 11429 $10,390 $11,184 $10,771
Cost of Revenue $6,939 $6,939 $7,261 $7,058
Gross Profit $4,490 $3,451 $3,923 $3,713
Product Development $991 $991 $1,026 $1,232
Marketing and Administrative $453 $453 $562 $606
Depreciation $520 $520 $559 $539
Amortization of Intangibles $23 $23 $53 $104
Restructuring and other, net ($22) ($22) $89 $178
Stock-based compensation $0 $0 $0 $0
Total Operating Expenses $1,965 $1,965 $2,289 $2,659
Income from Operations $2,525 $1,486 $1,634 $1,054
Interest Income $84 $38 $12 $12
Interest Expense ($224) ($236) ($222) ($222)
Other, net $25 ($18) ($29) ($29)
Other expenses, net ($115) ($216) ($239) ($239)
Income before Income Taxes $2,410 $1,270 $1,395 $815
(Benefit) provision for income taxes ($640) $236 $43 $43
Net Income $3,050 $1,034 $1,352 $772
         
         
         
NMG, Inc.        
Consolidated Balance Sheets  
(In millions except share and per share data) 2024 2023 2022 2021
as of December 31.        
Current Assets        
Cash and Cash Equivalents $2,220 $2,220 $1,853 $2,539
Accounts receivables, net 1070.098 $989 $1,184 $1,199
Inventories 1049.54 $970 $1,053 $982
Other current assets 188.6 $184 $220 $321
Total current assets $4,528 $4,363 $4,310 $5,041
Property, Equipment and leasehold improvements, net $1,869 $1,869 $1,792 $1,875
Investment in debt security $0 $0 $1,275 $0
Goodwill $1,237 $1,237 $1,237 $1,238
Other intangible assets, net $111 $111 $188 $281
Deferred income taxes $1,114 $1,114 $417 $609
Other assets, net $191 $191 $191 $224
Total Assets $9,050 $8,885 $9,410 $9,268
Current Liabilities        
Accounts payable 1625.9 $1,420 $1,728 $1,626
Accrued employee compensation 173.056 $169 $253 $237
Accrued warranty 91.7735 $91 $112 $113
Current portion of long-term debt $0 $0 $499 $0
Accrued expenses 587.328 $552 $598 $650
Total current liabilities 1890.7295 $2,232 $3,190 $2,626
Long-term accrued warranty 105.04 $104 $125 $120
Long-term accrued income taxes 4.368 $4 $10 $15
Other non-current liabilities 131.56 $130 $100 $122
Long-term debt less current portion 4295.53 $4,253 $4,320 $5,021
Total Liabilities 6427.2275 $6,723 $7,745 $7,904
Shareholders’ Equity        
Ordinary shares-par value $0.0001, 2.6 billion shares        
authorized, 1,354,218,154, and 1,340,697,595 shares        
issued and outstanding, respectively        
Additional paid in capital   $6,545 $6,377 $6,152
Accumulated other comprehensive Income (loss)   ($34) ($16) ($17)
Retained Earnings   ($4,349) ($4,696) ($4,771)
Total Shareholders' equity   $2,162 $1,665 $1,364
Total liabilities and shareholders' equity   $8,885 $9,410 $9,268
balance check   $0 $0 $0

Forecasting assumptions for 2024:

1- Revenue will grow by 10% and the tax rate will be 21%. 
 2- The CAPEX will be 6.5% of Revenue and Depreciation expense will be 6.2% of Property, equipment, and leasehold improvements gross at the start of the year which was $10, 985 million.
 3- The company issues $105 million of stock-based compensation, and it is fully vested. Additional paid-in capital will increase by the same amount. The company includes this form of compensation in operating expenses.
 4- The company has a dividend payout ratio of 25.6% of net income.
 5- No change in the following income statement accounts: Amortization of intangibles, Interest income, Interest expense, and Other, net.
 6- No change in the following balance sheet statement accounts: Goodwill, Long-term debts less current portion, Ordinary shares, Other comprehensive loss.
7- There is no change in macroeconomic readings, including the inflation rate.
8- The Restructuring and other, net is zero.
9- Consider the following accounts increase based on the percentage of the revenue in 2024.

Accounts receivable, net   8.20%
Inventories   8.20%
Other current assets   2.50%
Deferred income taxes   9.20%
Other assets, net   1.80%
Accounts payable   14.50%
Accrued employee compensation   2.40%
Accrued warranty   0.85%
Accrued expenses   6.40%
Long-term accrued warranty   1%
Other non-current liabilities   1.20%

RATIO AN

 

ALYSIS

    NMG 2023 2022 Industry Average
CURRENT RATIO     1.954749104 1.351097179 1.98
QUICK RATIO     1.872311828 1.282131661 1.24
INVENTORY TURNOVER (days)     0.1033204288 0.0904234122 93
INTEREST COVERAGE     -5.381355932 -6.283783784 4.26
ASSET TURNOVER (days)     1.169386607 1.188522848 529
RECEIVABLES TURNOVER (days)     0.09335899904 0.09415236052 58
GROSS MARGIN     33.21462945 35.07689557 32.50%
OPERATING MARGIN     14.30221367 14.61015737 7.30%
PROFIT MARGIN     9.951876805 12.08869814 5%
ROA     0.1163759145 0.1436769394 3.70%
ROE     0.1579831933 0.2120119178 6.70%
Debt to equity     1.027196333 1.214520935 1.01
Dividend pay-out ratio     264.704 346.112 0.28

References

Bustani, B., Khaddafi, M., & Ilham, R. N. (2022). Regional Financial Management System of Regency/City Regional Original Income In Aceh Province Period Year 2016-2020. International Journal of Educational Review, Law And Social Sciences (IJERLAS)2(3), 459-468.

Shim, J. K. (2022). Financial management. Professor of Finance and Accounting Queens College City University of New York.

Shapiro, A. C., & Hanouna, P. (2019). Multinational financial management. John Wiley & Sons.

Brigham, E. F., & Houston, J. F. (2021). Fundamentals of financial management: Concise. Cengage Learning.

Haydarov, U. (2020). Financial management system, tools, sources of investment activities and factors. Архив научных исследований35.

Mosteanu, N. R., & Faccia, A. (2020). Digital systems and new challenges of financial management–FinTech, XBRL, blockchain and cryptocurrencies. Quality–Access to Success21(174), 159-166.

You Might Also Like

Business Analytics Assignment Help

Comprehensive Guide on Case Study Writing: From Format to Conclusion

Get It Done! Today

Country
Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
+
  • 1,212,718Orders

  • 4.9/5Rating

  • 5,063Experts

Highlights

  • 21 Step Quality Check
  • 2000+ Ph.D Experts
  • Live Expert Sessions
  • Dedicated App
  • Earn while you Learn with us
  • Confidentiality Agreement
  • Money Back Guarantee
  • Customer Feedback

Just Pay for your Assignment

  • Turnitin Report

    $10.00
  • Proofreading and Editing

    $9.00Per Page
  • Consultation with Expert

    $35.00Per Hour
  • Live Session 1-on-1

    $40.00Per 30 min.
  • Quality Check

    $25.00
  • Total

    Free
  • Let's Start

Get
500 Words Free
on your assignment today

Browse across 1 Million Assignment Samples for Free

Explore MASS

Customer Feedback

Check out what our Student community has to say about us.

Read More

My Assignment Services- Whatsapp Get 50% + 20% EXTRAAADiscount on WhatsApp

Need Assistance on your
existing assignment order?