Question

In: Accounting

In http://es.finance.yahoo.com/ search the Profile (Profile) of PepsiCo (PEP) and IBM (IBM), and then, examine the Balance and the Result Account of each company.

1. In http://es.finance.yahoo.com/ search the Profile (Profile) of PepsiCo (PEP) and IBM (IBM), and then, examine the Balance and the Result Account of each company. Calculate the present value of the tax savings for interest that contributes to your long-term debt. Now suppose you each issue $ 3 trillion more of long-term debt and use the proceeds to buy back your own capital. What change would tax savings experience?

2. Scroll down and click on the word "Industry" in the left column. This will provide you with a table of financial ratios or ratios for different industries. Compare debt ratios between companies' equity. Can you explain the differences? Are these better explained according to the theory of equilibrium or according to that of the financial hierarchy?

3. What was Ryan's starting salary? How much could he have contributed to the voluntary savings plan in his first year of employment?

Solutions

Expert Solution

1.

Company Name

Debt

Interest Expense

Tax rate

Interest Rate

PepsiCo

$29,148,000

$1,135,000

36.7%

3.89% (Avg.)

IBM

$54,102,000

$1,344,000

23.1%

2.48% (Avg.)

 

Present Value of Interest Tax Shield for one year (PepsiCo) = (36.7%*$1,135,000)/(1+3.89%)^1

= $416,545/1.0389

= $400,948.12

 

Present Value of Interest Tax Shield for one year (IBM) = (23.1%*$1,344,000)/(1+2.48%)^1

=$310,464/1.0248

=$302,951

 

The value of PepsiCo exceeds the value of IBM by the present value of interest tax shield.According to M&M preposition, with taxes issuance of more debt will result more interest expense and reduction in taxable income. Both companies will attain more tax savings from interest expense on new debt.

Tax Savings (PepsiCo) = 36.7% * 3 Trillion = 1,101,000 million

Tax Savings (IBM) = 21.3% * 3 Trillion = 639,000 million

 

2.

Ratio

PepsiCo

IBM

Debt-to-equity

2.169

3.018

 

IBM having a higher debt-to-equity ratio indicates that it is leverage higher than PepsiCo with IBM using more creditor financing than investor financing. The higher ratio suggests IBM can easily serve its debt cost through cash flow and is using the advantage to increase return on equity and lower its cost of equity. However, PepsiCo having a higher tax rate has greater debt incentive and greater value of interest tax shield. The ratio for both the companies outline the theory of equilibrium of the capital structure. The choice of capital structure is a management decision where the firm’s capital structure is determined by its need for external financing to balance the benefit of debt against the costly equity cost.

 

The Value of Money over Time: Retirement Planning

 

3.

Current Salary

Growth Rate

Year

Previous Year's

Voluntary Savings

Salary

Contributions

$70,000.00

5%

1

$54,846.83

$6,033.15

$70,000.00

5%

2

$57,589.17

$6,334.81

$70,000.00

5%

3

$60,468.63

$6,651.55

$70,000.00

5%

4

$63,492.06

$6,984.13

$70,000.00

5%

5

$66,666.67

$7,333.33

 

Total

 

 

$33,336.97

 

Ryan’s first-year salary was $54,846.83 and he could have contributed $6,033.151 in his first year of employment. Additionally, if he has started the voluntary contribution saving plan five years ago with an 11% increase, the amount would have totaled $33,336.97 dollars.

 

If Ryan had taken advantage of the company's voluntary retirement plan to the maximum, each year for the past five years, how much money would he currently have accumulated in his retirement account, assuming monthly deposits and a nominal rate of return of 7 %? How much more would the value of his investment have been if he had opted for a higher risk alternative (for example, 100% in common shares), which are expected to yield an average rate of return of 12%?

Annual Rate

Monthly Rate

NPER

Contribution Amount

Future Value

Accumulated Amount

7%

0.583%

60

$33,337.00

$47,259

$13,922.37

12%

1.000%

60

$33,337.00

$60,563

$27,226.22

Had Ryan taken advantage of the voluntary retirement plan up to maximum with monthly deposits, every year for the past five year, he would currently have a balance of $47,259 at nominal rate of 7% or $60,563 with an average 12% rate of return in his retirement account. Comparing the two rates of return, there is a difference of $13,303.84 in the growth of the two options.

 

Monthly Deposits if compounded monthly

Year

Accumulated Amount

1

12,066.30

2

12,669.62

3

13,303.10

4

13,968.25

5

14,666.67

Total

66,673.94

NPV

$56,866.79

 

Rate

7%

12%

No of Periods

60

60

Future Value

$80,135.96

$102,694.79

 

With monthly deposits, compounded monthly at 7% nominal rate of return, he would have accumulated $80,136or $102,695 with compounded 12% rate of return. Comparing the two rates of return, there is a difference of $22,559 in the growth of the two options.


$102,694.79

 

Related Solutions

Answer this fully please PepsiCo, Inc. (PEP), the parent company of Frito-Lay snack foods and Pepsi...
Answer this fully please PepsiCo, Inc. (PEP), the parent company of Frito-Lay snack foods and Pepsi beverages, had the following current assets and current liabilities at the end of two recent years: Current Year (in millions) Previous Year (in millions) Cash and cash equivalents $9,158 $9,096 Short-term investments, at cost 6,967 2,913 Accounts and notes receivable, net 6,694 6,437 Inventories 2,723 2,720 Prepaid expenses and other current assets 1,547 1,865 Short-term obligations 6,892 4,071 Accounts payable 14,243 13,507 a. Determine...
Calculate and enter the ending balance for each t-account. Post each transaction from the T-account into...
Calculate and enter the ending balance for each t-account. Post each transaction from the T-account into the ledger. Enter the transactions in chronological order. Explanations and posting references are not required. Then, calculate and enter the ending balance of each ledger account. Leave any unused cells blank. Trademark Dec. 1 33,700 29,000 Dec. 3 Dec. 2 6,700 13,200 Dec. 5 Dec. 4 26,800 6,900 Dec. 8 Dec. 6 13,400 1,300 Dec. 9 Dec. 7 31,300 19,500 Dec. 10 Bal. Bal....
1. The trial balance will include a.the ending balance of each account. b.only the debits of...
1. The trial balance will include a.the ending balance of each account. b.only the debits of each account. c.only the credits of each account. 2. The unadjusted trial balance is prepared a.prior to determining the account balance in the ledger. b.after the journal entries are posted. c.prior to posting the journal entries. d.only if errors are suspected. d.only balance sheet accounts.
Which of the following will probably NOT result in an improved current account balance (assuming everything else remains constant)?
6 Which of the following will probably NOT result in an improved current account balance (assuming everything else remains constant)? a. a decrease in a country's national income level b. a decrease in a country's rate of inflation c. an increase in government restrictions in the form of tariffs or quotas d. an appreciation of a country's currency 2 points7 Under a managed float exchange rate system, the Fed may attempt to stimulate the U.S. economy by ____ the dollar. Such...
Question 2 A balance sheet is often used by analysts to examine a company from a...
Question 2 A balance sheet is often used by analysts to examine a company from a financial point of view. Describe the strengths and weaknesses of the document for this purpose. Describe the budgeting process, and discuss why the budgeting process is often difficult and time-consuming. Explain the following costing methods and discuss their advantages and disadvantages: estimating methods, standard costing methods, detailed analysis methods. Explain the four basic steps in the multi-attribute analysis technique.
1. Take the Starbucks balance sheet (2018) and calculate the % of each account to the...
1. Take the Starbucks balance sheet (2018) and calculate the % of each account to the total of that section of the balance sheet (cash as a % of total assets, ST investments as a % of total assets......., then A/P as a % total of total liabilities, etc) Do this for all categories under assets, liability and equity. Perform the calculations on 2018 only. 2. What is the accounting equation for Starbucks as of 2017 and 2018? 3. What...
a) For each of the following, identify in which part of Zambia’s balance-of-payments account it appears...
a) For each of the following, identify in which part of Zambia’s balance-of-payments account it appears (current account, capital account, or method of financing) and whether it is a receipt or a payment. i) A foreigner purchases shares from ZCCM-IH. ii) A Zambian purchases an airline ticket from Kenyan Airways. iii) The Malawian government’s purchase of Zambian Treasury bills. iv) A South African purchase of Zambian Tea. v) K50 million of donation to Zimbabwe. b) A central bank sale of...
For each of the following cases determine the ending balance in the inventory account. (Hint: First,...
For each of the following cases determine the ending balance in the inventory account. (Hint: First, determine the total cost of inventory available for sale. Next, subtract the cost of the inventory sold to arrive at the ending balance.) a. Jill’s Dress Shop had a beginning balance in its inventory account of $47,500. During the accounting period, Jill’s purchased $97,500 of inventory, returned $6,500 of inventory, and obtained $900 of purchases discounts. Jill’s incurred $1,300 of transportation-in cost and $750...
Lasko Trial Balance as of 12/31/17 each account has a normal balance. Use this financial information...
Lasko Trial Balance as of 12/31/17 each account has a normal balance. Use this financial information to answer the questions below. Unearned Revenue $25,000 Supplies $15,500 Sales $140,000 Salaries Expense $22,000 Retained Earnings $29,000 Rent Expense $18,600 Additional Paid in Capital $76,000 Insurance Expense $4,500 Prepaid Insurance $6,000 Office Equipment $50,000 Notes Payable (Due 06/30/2018) $12,000 Dividends $5,000 Cost of Goods Sold $72,400 Cash $80,000 Capital Stock $1 par $4,000 Accumulated Depreciation $15,000 Accounts Receivable $72,000 Depreciation Expense $5,000 Accounts...
The current balance in the cash account of Williams Company is $942. Which of the following...
The current balance in the cash account of Williams Company is $942. Which of the following figures, if included on the trial balance as the cash account balance, would represent a transposition error? Multiple Choice $94.20 $902 $924 $940
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT