Fill This Form To Receive Instant Help
Homework answers / question archive / 1
1. Use the Balance Sheet and Income Statement information to calculate ROE in 2018 using the DuPont Identity: U.S. CORPORATION 2017 and 2018 Balance Shoots ($ In millons) Assets Labilities and Owners' Equity 2017 2018 2017 2018 Current assets Current liabilities Cash $ 104 221 Accounts payable $ 232 Accounts receivable 455 688 Notes payable Inventory 553 555 Total $ 428 $ 389 Total $1,112 $1,464 Fixed assets Net plant and Long-term debt $ 408 $ 454 equipment $1,644 $1,709 Owners' equity Common stock and paid-in surplus Retained earnings 1,320 1,690 Total $1,920 $2,330 Total liabilities and Total assets $2,756 $3.173 owners' equity $2,756 $3,173 $ 266 123 196 600 640 U.S. CORPORATION 2018 Income Statement ($ in millions) Net sales Cost of goods sold Depreciation Earnings before interest and taxes Interest paid Taxable income Taxes (21%) Net income Dividends Addition to retained earnings $1,509 750 65 $ 694 70 $ 624 131 $ 493 $123 370.
2.Statement of Cash Flows and Standardized Financial Statements a) Net income for your firm was $10,000 last year. The depreciation expense was $2,500; accounts receivable increased $1,250; accounts payable increased $800; and inventories increased by $2,000. Identify the sources and uses of cash • What was the total cash flow from operations for the period? Operating activities = Net Income + Depreciation + Source (inflow) - Use foutflow) b) i) Prepare the 2018 common-size Income Statement given: U.S. CORPORATION 2018 Income Statement ($ in millions) Net sales Cost of goods sold Depreciation Earnings before interest and taxes Interest paid Taxable income Taxes (21%) Net Income $1,509 750 65 $ 694 70 $ 624 131 $ 493 Dividends Addition to retained earnings $123 370
Income Statement Common-size Sales Cost of Goods Sold Depreciation EBIT Taxable income Interest Taxes Net Income b) ii) Prepare the 2018 (base year-2017) common-base year Balance Sheet given: Assets 2017 2018 US CORPORATION 2017 and 2018 Balance Sheets in millions Liabilities and Owners Equity 2018 2017 Current liabilities $ 221 Accounts payable $ 232 688 Notes payable 196 555 Total $ 428 $1,464 Current assets Cash Accounts receivable Inventory Total Fixed assets Net plant and equipment $ 104 455 553 $1,112 $ 206 123 $ 389 Long term debt $ 408 $ 454 $1.644 $1.709 Owners' equilty Common stock and pald-in surplus Retained earnings Total Total liabilities and owners' equity 600 1.320 $1.920 6-40 1,690 $2,330 Total assets $2.756 $3,173 $2.756 $3,173
Assets Liabilities and Equity Common-Base Year Common-Base Year Cash A/R Inventory Net Fixed Assets A/P Notes Payable Long term debt Common Stock Total Assets Ret Earnings Total Liabilities and Equity.
3.Show your complete solution, you may type your solution Follow Given, Required, Solution - Format 1. Find the nominal interest rate, effective interest rate, and rate per compounding period given the following interest rates: a. 12% compounded semi-annually b.4% compounded quarterly c. 18% compounded monthly d. 26% compounded weekly 2. What nominal interest rate is paid if compounding is annual and a. Payments of 4,500 per year for six years will repay an original loan of $17,000? b. Annual deposits of P1,000 will result in 125,000 at the end of 10 years? 3. A five-seven loan company offers money at 1% interest per week compounded weekly. What is the effective annual interest rate? What is the nominal interest rate? (Use 52 weeks = 1 year) 4. Jay borrowed P10,000 and was able to sign a promissory note that he would pay P20,327.90 after 4 years. How much is the nominal rate of interest and the corresponding effective rate if money is compounded bi-monthly 5. Compare accumulated amounts after years 11.000 invested at the rate of 10% per year compounded: (a) annually. (b) semi-annually. Id quarterly, and (d) monthly.
1.
Profit Margin = Net income / Sales
= $ 493 / $1509
= 0.32670642809
Total Asset Turn over = Net sale / Total Asset
= $1509 / $2756
= 0.54753265602
Equity Multiplier = Total Asset / Owners equity
= $2756 / $2330
= 1.18283261803
ROE = Profit Margin * Total Asset Turn over * Equity Multiplier
= 0.32670642809 * 0.54753265602 * 1.18283261803
= 0.21158798266 or 21.15 %
2.
Identification of Source of Cash Inflow and outflow :
Source of Cash (Inflow) = Increase in Accounts Payable $800
Use of Cash (Outflow) = Increase in Accounts Receivable $1250 and increase in Inventory $2000.
Cash Flow from Operations = Net Income + Depreciation + Source (Inflow) - Source (Outflow)
= 10000 + 2500 + 800 - (2000 + 1250)
= 10050
(b.) Common Size income statement is the income statement where each individual item is expressed as total of sales.Below is the common Size Income statement :
Particulars | Amount | Individual item / Sale | % of sales |
Net Sales | 1509 | 1.00 | 100.00% |
Less :Operating Cost except Depreciation and amortization | 750 | 0.4970 | 49.70% |
Less :Depreciation | 65 | 0.0431 | 4.31% |
Operating Income (or EBIT) | 694 | 0.46 | 45.99% |
Less :Interest Expenses | 70 | 0.046 | 4.64% |
Taxable Income | 624 | 0.4135 | 41.35% |
Less :Taxes @21% | 131 | 0.0868 | 8.68% |
Net Income | 493 | 0.3267 | 32.67% |
(b.) (ii) Common Size Balance Sheet :
Common Size Balance sheet is prepared by divideng Individual Amount of Current year with thge amount in base year.
Assets | Common Size base year | Liabilities & owner's Equity | Amount |
Cash | 2.125 | Accounts Payable | 1.146552 |
Accounts Receivable | 1.512087912 | Notes Payable | 0.627551 |
Inventory | 1.003616637 | ||
Long Term Debt | 1.112745 | ||
Net Plant and Equipment | 1.039537713 | Common Stock and Paid in Surplus | 1.066667 |
Retained Earnings (269380+85162) | 1.280303 | ||
Total Assets | 1.151306 | Total Liabilities &owner's Equity | 1.151306 |
3.Please use this google drive link to download the answer file.
https://drive.google.com/file/d/1j8TuGpwXooNlomRc3tChg_1JHEQDzvzJ/view?usp=sharing
Note: If you have any trouble in viewing/downloading the answer from the given link, please use this below guide to understand the whole process.
https://helpinhomework.org/blog/how-to-obtain-answer-through-google-drive-link
Part 2
We are going to use IRR formula to calculate Effective interest rate. In this case compounding is annual so Effective interest rate is same as Nominal Interest rate.
part 3
1% per week compounded weekly
So effective rate is 1%*52= 52%
i= 52%
Now we need to calculate r ( Nominal rate )
Compounded weekly so n= 52
Part 4
Borrowed 10000 in year 0 and paid back with interest in 4 years