FIN_6060_MILESTONE_2 8TH
docx
keyboard_arrow_up
School
Thompson Rivers University *
*We aren’t endorsed by this school
Course
6060
Subject
Accounting
Date
Apr 3, 2024
Type
docx
Pages
6
Uploaded by MagistratePolarBearMaster950
Milestone 2: GM Pro Forma Statements AKINLDE TEMITOPE DAMILOLA Nexford University FIN 6060: Financial Decision Making Dr. Keith Wade FEBUARY 2024
GM’s Pro forma income statement As at DEC 2017 2017 2018 Total Sales automotive 133,449 146,793.9 Cost of sales for automotive 114,869 126,355.9 Net sales 145,588 160,146.80 operating costs 0 automotive, general, and administrative expense 9,575 10532.5 GM financial interest operating and other expenses 11,128 12240.8 Total operating expense 135,572 149129.2 operating Income 10,016 11017.6 income before tax 11,863 13,049.3 Income tax expense 11,533 11,533 Income from continuing operations 330 363 Net income (3882) 1846.30 GM'S Ero forma balance sheet current assets cash and cash equivalent 15512 17063.2 Marketable securities 8313 9144.3 Accounts and notes receivable (net of allowance of $278 and $212) 8164 8980.4 GM Financial receivables, net 20521 22573.1 Inventories 10663 11729.3 Other current assets 4465 4911.5 Total current assets 68744 75618.4 Noncurrent assets GM Financial receivables, net 21208 23328.8 Equity in net assets of nonconsolidated affiliates 9073 9980.3 Property, net 36253 39878.3 Goodwill and intangible assets, net 5849 6433.9 Equipment on operating leases, net 42882 47170.2
Deferred income taxes 23544 Other assets 4929 5421.9 Total non-current assets 143738 158111.8 Total Assets 212482 233730.2 LIABILITIES AND EQUITY Current liabilities Accounts payable (principally trade) 23929 26321.9 Short-term debt and the current portion of long-term debt Automotive 2515 2766.5 GM Financial 24450 26895 Accrued liabilities 25996 28595.6 Total current liabilities 76890 84579 Non-current Liabilities Long-term debt Automotive 10987 12085.7 GM Financial 56267 61893.7 Postretirement benefits other than pensions 5998 6597.8 Pensions 13746 15120.6 Other liabilities 12394 13633.4 Total non-current liabilities 99392 109331.2 Total Liabilities 176282 193910.2 EQUITY Common stock, $0.01 par value 14 15.4 Additional paid-in capital 25371 27908.1 Retained earnings 17627 19389.7 Accumulated other comprehensive loss -8011 -8812.1 Total stockholders’ equity 35001 38501.1 Noncontrolling interests 1199 Total Equity 36200 39820 Total Liabilities and Equity 212482 233730.2 GM'S PRO FORMA STATEMENT OF CASHFLOW Catego Cash flows from operating activities Income from continuing operations 330 363 Depreciation, amortization, and impairment charges 12261 13487.1 Foreign currency remeasurement and transaction losses 52 57.2 Undistributed earnings of nonconsolidated affiliates, net -132 -145.2 Pension contributions and OPEB payments -1636 -1799.6 Provision (benefit) for deferred taxes 10880 10880
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Change in other operating assets and liabilities -3015 Other operating activities -468 Net cash provided by operating activities — continuing operations 17338 Net cash used in operating activities — discontinued operations -10 Net cash provided by operating activities 17328 Cash flows from investing activities Expenditures for property -8453 Available-for-sale marketable securities, acquisitions -5503 Available-for-sale marketable securities, liquidations 9007 Acquisition of companies/investments, net of cash acquired -41 Purchases of finance receivables, net -19325 Principal collections and recoveries on finance receivables 12578 Purchases of leased vehicles, net -19180 Proceeds from termination of leased vehicles 6667 of leased vehicles 6,667 2,554 1,095 Other investing activities 178 Net cash used in investing activities — continuing operations -24072 Net cash used in investing activities — discontinued operations -3500 Net cash used in investing activities -27572 Cash flows from financing activities Net decrease in short-term debt -140 Proceeds from issuance of debt (original maturities greater than three months) 52187 Payments on debt (original maturities greater than three months) -33592 Payments to purchase common stock -4492 Proceeds from the issuance of GM Financial preferred stock 985 Dividends paid -2233 Other financing activities -305 Net cash provided by financing activities — continuing operations 12410 Net cash provided by financing activities — discontinued operations 174 Net cash provided by financing activities 12584 Effect of exchange rate changes on cash, cash equivalents and restricted cash 348 Net increase (decrease) in cash, cash equivalents and restricted cash 2688 Cash, cash equivalents and restricted cash at beginning of period 15160 Cash, cash equivalents and restricted cash at end of period 17848 Ratio Analysis The utilization of quantitative metrics for the purpose of evaluating the financial performance of a particular organization is what is known as ratio analysis. Through the utilization of this methodology, it is possible to acquire substantial insights into the profitability, operational efficiency, solvency, and liquidity of the company, as demonstrated by its financial statements. According to Vaidya (2019), the profitability ratio is a method that examines a company's potential to generate profits in relation to its balance sheet assets, revenues, operating expenses, or equity, using the most recent information available. According to Hayes (2023), the utilization of liquidity measures is necessary in order to -3316.5 -514.8 19071.8 -11 19060.8 0 -9298.3 -6053.3 9907.7 -45.1 -21257.5 13835.8 -21098 7333.7 195.8 -26479.2 -3850 -30329.2 0 -154 57405.7 -36951.2 -4941.2 1083.5 -2456.3 -335.5 13651 191.4 13842.4 382.8 2956.8 16676 19632.8
evaluate a debtor's capability of meeting current debt commitments without relying on money from outside sources. The ratios evaluate a company from the perspective of its capacity to repay its debts as well as the level of security that they offer. Calculating indicators such as the current ratio, quick ratio, and operating cash flow ratio is the method that is utilized to accomplish this.(Hayes, 2023) Net profit Ratio Net profit/Net sales -3% 1.2% Current Ratio Current assets/Current liability 1 1 Gross profit ratio Gross profit/Net sales 7% 7% Return on assets ratio Net profit/Total assets -2% 0.8% Net income/shareholder Return on equity equity -11% 4.8% Inventory turnover ratio cost of sales/inventories 12.71425 12.71425 Additional funds Needed (AFN) = expected increase in assets — automatic increase in liabilities — expected increase in retained earnings Increase in Assets = current year’s assets X sales growth rate = $212,482 billion x 10% =$ 21,248.2 billion Increase in liabilities = Current years liabilities x sales growth rate = 176,282 billion x 10% = $ 17,682 billion
Expected increase in retained earnings = $ 17,627 x 10% = $ 1,762.7 AFN =$21,248.2-%$17,682-%1,762.7 = $1,803.5 AFN = $1,803.5 billion Recommendation It is of the utmost importance to investigate the effects of the considerable tax burden that General Motors imposes on its high income, which calls for reform. The only reliance on return on equity (ROE) and return on assets (ROA) is insufficient to ensure the long-term viability of the firm. Therefore, it is essential to implement a new strategic and business model in order to guarantee the company's prosperity. Additionally, General Motors does not completely optimize the exploitation of its assets, despite the fact that it has enough liquidity. In order to determine how successfully a firm makes use of its assets and liabilities in order to generate sales and profits, efficiency ratios are utilized. The computation requires determining how effectively inventories are being utilized, how effectively machinery is being utilized, how effectively liabilities are being converted, and how effectively equity is being utilized. Because they have the ability to increase a company's income and earnings, improvements to efficiency ratios are extremely important. Year 2022, Team CFI The findings of the study that was presented earlier make it abundantly evident that General Motors is not making efficient use of its assets. The fact that its ROA ratio is only 0.8%, which is insufficient for a company of its scale, lends credence to this assertion. Due to the fact that this expansion will result in a bad net profit ratio of only 1.2%, it is suggested that General Motors refrain from the pursuit of this growth. Taking into account the fact that the corporation requires 1,803.5 billion dollars in order to carry out the growth, this ratio is regarded as being insufficient.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Problem 11-5 (IAA)
Pro
Tragie Company provided the following data for purchases
and sales:
Sla
rela
Purchases
Unit cost
Sales
Revenue
Ja.
Ag
Units
Cost
Units
250,000
540,000
1,125,000
4,000
7,000
12,000
280,000
630,000
1,200,000
50
2018
2019
2020
5,000
9,000
15,000
75
Required:
Compute the gross income for 2020 assuming a FIFO cost
formula.
arrow_forward
please explain the result of income statement that provided in image below
arrow_forward
Problem 13-02A (Video)
The comparative statements of Cullumber Company are presented here:
Cullumber CompanyIncome StatementsFor the Years Ended December 31
2020
2019
Net sales
$1,891,640
$1,751,600
Cost of goods sold
1,059,640
1,007,100
Gross profit
832,000
744,500
Selling and administrative expenses
501,100
480,100
Income from operations
330,900
264,400
Other expenses and losses
Interest expense
23,700
21,700
Income before income taxes
307,200
242,700
Income tax expense
93,700
74,700
Net income
$213,500
$168,000
Cullumber CompanyBalance SheetsDecember 31
Assets
2020
2019
Current assets
Cash
$60,100
$64,200
Debt investments (short-term)
74,000
50,000
Accounts receivable
118,900
103,900
Inventory
127,700
117,200
Total current assets
380,700
335,300
Plant assets (net)…
arrow_forward
Answer the whole page
arrow_forward
32
arrow_forward
please answer do not image
arrow_forward
Please solve this question general accounting
arrow_forward
Operating and Nonoperating Items in Boston Scientific's Income Statement
EXHIBIT 3.6
For Year Ended December 31, S mllllons
2018
2017
2016
Net sale .
Cost of products sold
$9,823
$9,048
2,593
$8,386
2,424
2,813
Gross profit.
Operating expenses
Selllng, general and admlnIstratlve expenses.
Research and development expenses
Royalty expense
Amortlzatlon expense
Intanglble asset Impalrment charges
ContIngent conslderatlon expense (beneflt) .
RestructurIng charges.
LItigatlon-related charges
7,010
6,455
5,962
3,569
1,113
3,294
3,099
997
920
70
68
79
599
565
545
35
4
11
(21)
(80)
29
36
37
28
103
285
804
Operating expenses -
5,504
5,170
5,515
Operating income .
Other expense (income)
Interest expense
1,506
1,285
447
241
229
233
Other expense (income), net.
(156)
124
37
Income before income taxes
1,422
932
177
Income tax expense (benefit) .
(249)
828
(170)
Net income.
$1,671
$
104
$ 347
Calculate the operating expense margin ratio for 2016
arrow_forward
Prepare the Pro-Forma Statement of Financial Position for the year ending 31 December 2023
INFORMATIONSibiya ProjectsStatement of Comprehensive Income for the year ended 31 December 2022 RSales 10 000 000Cost of sales (5 750 000)Gross profit 4 250 000Variable, selling and administrative costs (1 500 000)Fixed selling and administrative costs (500 000)Net profit 2 250 000
Statement of Financial Position for the year ended 31 December 2022ASSETS RNon-current assets 800 000Property, plant and equipment 800 000
Current assets 3 400 000Inventories 1 600 000Accounts receivable 600 000Cash 1 200 000TOTAL ASSETS 4 200 000
EQUITY AND LIABILITIESEquity 3 760 000
Current liabilities 440 000Accounts payable 440 000TOTAL ASSETS AND LIABILITIES 4 200 000
Additional informationA. The sales budget for 2023 is as follows:First Quarter Second Quarter Third Quarter Fourth QuarterR2 625 000 R2 750 000 R2 875 000 R2 750 000
B. 90% of sales is collected in the quarter of the sale and 10% in the quarter…
arrow_forward
ASSESSMENT:
Problem #1: On June 30, 2020, PSA Trading Co. has the following informatign:
revenue from sales is Po8,760; sales return is P35,50o; cost of goods sold is P8.490:
salaries cost P 14,600; rent is P8,090; light and water expenses are P7.550 and
miscellaneous expenses are Po,520.Generate an income statement and find:
a. Gross Profit
b. Net Profit or Loss
Problem #2: AMA 6operative store had the following activities for year ended
2021: gross sales amounting to Po4,653, the cost of goods sold was P48,923, the
operating expensés were, P8,723.15, and refunds for defective goods amounted to
P26,497.15. Generate an income slatemeni and find:
a. Net Sales
b. Gross Profit
c. Net Profit
Problem #3: AMA cooperative store had the following activities for year ended 2021:
gross sales amounting to P94,653, the cost of goods sold was P48,923, the operating
expenses were, P8,723.15, and refunds for defective goods amounted to P26,497.15.
Generate an income statement and find:
a. Net Sales…
arrow_forward
64
The portion of the functional income statements of Brief Company for 2021 and 2020 are presented below:
2021
2020
Sales
P890,000
P800,000
Cost of goods sold
530,000
450,000
Gross margin
360,000
350,000
Assuming that effective January of 2021 the unit cost is higher by 6 percent, calculate the change in sales due to change in volume rounded to nearest thousands.
Group of answer choices
P85,000 Favorable
P88,000 Favorable
P85,000 Unfavorable
P88,000 Unfavorable
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Related Questions
- Problem 11-5 (IAA) Pro Tragie Company provided the following data for purchases and sales: Sla rela Purchases Unit cost Sales Revenue Ja. Ag Units Cost Units 250,000 540,000 1,125,000 4,000 7,000 12,000 280,000 630,000 1,200,000 50 2018 2019 2020 5,000 9,000 15,000 75 Required: Compute the gross income for 2020 assuming a FIFO cost formula.arrow_forwardplease explain the result of income statement that provided in image belowarrow_forwardProblem 13-02A (Video) The comparative statements of Cullumber Company are presented here: Cullumber CompanyIncome StatementsFor the Years Ended December 31 2020 2019 Net sales $1,891,640 $1,751,600 Cost of goods sold 1,059,640 1,007,100 Gross profit 832,000 744,500 Selling and administrative expenses 501,100 480,100 Income from operations 330,900 264,400 Other expenses and losses Interest expense 23,700 21,700 Income before income taxes 307,200 242,700 Income tax expense 93,700 74,700 Net income $213,500 $168,000 Cullumber CompanyBalance SheetsDecember 31 Assets 2020 2019 Current assets Cash $60,100 $64,200 Debt investments (short-term) 74,000 50,000 Accounts receivable 118,900 103,900 Inventory 127,700 117,200 Total current assets 380,700 335,300 Plant assets (net)…arrow_forward
- Please solve this question general accountingarrow_forwardOperating and Nonoperating Items in Boston Scientific's Income Statement EXHIBIT 3.6 For Year Ended December 31, S mllllons 2018 2017 2016 Net sale . Cost of products sold $9,823 $9,048 2,593 $8,386 2,424 2,813 Gross profit. Operating expenses Selllng, general and admlnIstratlve expenses. Research and development expenses Royalty expense Amortlzatlon expense Intanglble asset Impalrment charges ContIngent conslderatlon expense (beneflt) . RestructurIng charges. LItigatlon-related charges 7,010 6,455 5,962 3,569 1,113 3,294 3,099 997 920 70 68 79 599 565 545 35 4 11 (21) (80) 29 36 37 28 103 285 804 Operating expenses - 5,504 5,170 5,515 Operating income . Other expense (income) Interest expense 1,506 1,285 447 241 229 233 Other expense (income), net. (156) 124 37 Income before income taxes 1,422 932 177 Income tax expense (benefit) . (249) 828 (170) Net income. $1,671 $ 104 $ 347 Calculate the operating expense margin ratio for 2016arrow_forwardPrepare the Pro-Forma Statement of Financial Position for the year ending 31 December 2023 INFORMATIONSibiya ProjectsStatement of Comprehensive Income for the year ended 31 December 2022 RSales 10 000 000Cost of sales (5 750 000)Gross profit 4 250 000Variable, selling and administrative costs (1 500 000)Fixed selling and administrative costs (500 000)Net profit 2 250 000 Statement of Financial Position for the year ended 31 December 2022ASSETS RNon-current assets 800 000Property, plant and equipment 800 000 Current assets 3 400 000Inventories 1 600 000Accounts receivable 600 000Cash 1 200 000TOTAL ASSETS 4 200 000 EQUITY AND LIABILITIESEquity 3 760 000 Current liabilities 440 000Accounts payable 440 000TOTAL ASSETS AND LIABILITIES 4 200 000 Additional informationA. The sales budget for 2023 is as follows:First Quarter Second Quarter Third Quarter Fourth QuarterR2 625 000 R2 750 000 R2 875 000 R2 750 000 B. 90% of sales is collected in the quarter of the sale and 10% in the quarter…arrow_forward
- ASSESSMENT: Problem #1: On June 30, 2020, PSA Trading Co. has the following informatign: revenue from sales is Po8,760; sales return is P35,50o; cost of goods sold is P8.490: salaries cost P 14,600; rent is P8,090; light and water expenses are P7.550 and miscellaneous expenses are Po,520.Generate an income statement and find: a. Gross Profit b. Net Profit or Loss Problem #2: AMA 6operative store had the following activities for year ended 2021: gross sales amounting to Po4,653, the cost of goods sold was P48,923, the operating expensés were, P8,723.15, and refunds for defective goods amounted to P26,497.15. Generate an income slatemeni and find: a. Net Sales b. Gross Profit c. Net Profit Problem #3: AMA cooperative store had the following activities for year ended 2021: gross sales amounting to P94,653, the cost of goods sold was P48,923, the operating expenses were, P8,723.15, and refunds for defective goods amounted to P26,497.15. Generate an income statement and find: a. Net Sales…arrow_forward64 The portion of the functional income statements of Brief Company for 2021 and 2020 are presented below: 2021 2020 Sales P890,000 P800,000 Cost of goods sold 530,000 450,000 Gross margin 360,000 350,000 Assuming that effective January of 2021 the unit cost is higher by 6 percent, calculate the change in sales due to change in volume rounded to nearest thousands. Group of answer choices P85,000 Favorable P88,000 Favorable P85,000 Unfavorable P88,000 Unfavorablearrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education