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 |
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).
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 |
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 |
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 Success, 21(174), 159-166.
You Might Also Like
Business Analytics Assignment Help
Comprehensive Guide on Case Study Writing: From Format to Conclusion
1,212,718Orders
4.9/5Rating
5,063Experts
Turnitin Report
$10.00Proofreading and Editing
$9.00Per PageConsultation with Expert
$35.00Per HourLive Session 1-on-1
$40.00Per 30 min.Quality Check
$25.00Total
FreeGet
500 Words Free
on your assignment today
Get
500 Words Free
on your assignment today
Doing your Assignment with our samples is simple, take Expert assistance to ensure HD Grades. Here you Go....
🚨Don't Leave Empty-Handed!🚨
Snag a Sweet 70% OFF on Your Assignments! 📚💡
Grab it while it's hot!🔥
Claim Your DiscountHurry, Offer Expires Soon 🚀🚀