Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / 1

1

Finance

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.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

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