Read PepsiCo’s (NYSE:PEP) most recent 10-K (2019-2-15), its Proxy (DEF 14 A, 2019-3-22 and answer or produce the following:go to www.sec.gov/edgar/searchedgar/companysearch.html and search for Pepsi

1. As an analyst and using the Company’s “Long-term debt obligations” schedule as a guideline, what would you estimate the Company’s cost of borrowing to be?

2. Pepsico manages its business in “reportable segments”. List them.

3. Which is the largest segment in terms of revenue? In terms of operating profit

4. As an analyst, which two risk factors (Risk Factors Item 1a) do you consider the most important? Please ensure that your answer includes your reasoning why?

5. What was the Company’s “free cash flow” in 2018 and 2017?

6. “Operations outside of the United States generated” what percent of the Company’s consolidated net revenue?Go to

Greenpoint Corporation is considering a new investment. Financial projections for the investment are tabulated here. The corporate tax rate is 25 percent. Assume all sales revenue is received in cash, all operating costs and income taxes are paid in cash, and all cash flows occur at the end of the year. All net working capital is recovered at the end of the project. Suppose the appropriate discount rate is 12 percent. Determine the net working capital spending for Year 4 then calculate the NPV of the project. What is the project NPV?

Loki Labs is experience rapid growth due the increased demand for dog treat products that are low in calories and high in nutrition. Current sales of $125,000, which increased from $90,000 the previous month, are expected to grow at a 25 percent rate. Costs of sales are stable at 75% of sales revenue. Loki's sales are for 30 percent cash with the remaining 70 percent collected the following month. Inventory-on-hand is maintained at a level to support the following month's sales. Inventory is paid in full at the time of receipt. Loki's cash balance at the start of the period was $75,000.

A. For the current month and the following three months, determine Loki's

1. Revenue                                              
2. Inventory                                              
3. Cost of sales                                       
4. Accounts receivable                                         
5. Cash collections                                               
6. Cash disbursements                                         

B. Is Loki's gross profit increasing or declining?                       

C. Is Loki's cash flow increasing or declining?              

D. What is Loki's cash balance at the end of the four-month period?

Greenpoint Corporation is considering a new investment. Financial projections for the investment are tabulated here. The corporate tax rate is 25 percent. Assume all sales revenue is received in cash, all operating costs and income taxes are paid in cash, and all cash flows occur at the end of the year. All net working capital is recovered at the end of the project. Suppose the appropriate discount rate is 12 percent. Determine the net working capital spending for Year 4 then calculate the NPV of the project. What is the project NPV? Year 0 Year 1 Year 2 Year 3 Year 4 Investment $118,000 Sales revenue $75,000 $75,800 $77,000 $78,500 Operating cost 18,000 18,600 19,600 21,000 Depreciation 29,500 29,500 29,500 29,500 Net working capital spending 10,000 4,000 2,000 1,000 ? $30,532.66 $29,744.78 $28,568.41 $27,520.33 $26,244.80

Khalifa Computers has 3,000 shares of common stock outstanding. The company also has the following amounts in revenue and expense accounts.

Calculate:                                                                                                                   

1. Gross profits.
2. Operating profits.
3. Net profits after taxes (assume a 30 percent tax rate).
4. Calculate the depreciation using MACRS approach for an asset which costs $85,000 and is being depreciated using a 5-year normal recovery period (depreciation rate is as follows: 20%, 32%, 19%, 12%, 12% and 5%). Will the depreciation amount be difference in case of straight line method when the scrap value of the asset is $5,000?

One year ago your company purchased a machine for $110,000. You have learned that a new, much better machine is available for $150,000--it will be depreciated on a straight line basis and has no salvage value. You expect the machine to produce $60,000 per year in revenue and cost $20,000 per year to operate for the next ten years. The current machine is expected to produce $40,000 per year in revenue and also costs $20,000 per year to operate. The current machine’s depreciation expense is $10,000 per year for the next 10 years, after which it will be discarded. It will have no salvage value. The market value of the current machine today is $50,000. Your company’s tax rate is 45% and the opportunity cost of capital is 10%. Should your company replace its year-old machine?

PLEASE SHOW ALL WORK

The Katy Company engages in the manufacture and sale of books worldwide. Its income statement for the year ending June 30, 2019 and selected amounts from its June 30, 2019 balance sheet follow:

The following information pertains to the York Company for the year ending December
31, 2019.

$ Hours
Revenue 240,000
Interest Revenue 50,000
Raw materials used 40,000
Indirect Labour 4,000
Indirect Materials 9,000
Utilities [factory] 4,500
Depreciation of factory equipment 10,000
Depreciation of factory buildings 19,000
Depreciation of admin buildings 5,000
Marketing costs 30,000
Wages [Store] 10,000
Utilities [store] 6,000
Supplies [store] 3,500
Direct Labour Hours 2000
Hourly Rate for direct labour 10
Finished Goods Inventory Jan 1 2019 7,000
Finished Goods Inventory Dec 31 2019 15,000
Bond Payable 65,000
Interest Rate 10%
Tax rate 22%

REQUIRED
1. Prepare a budgeted COGS statement
2. Prepare a projected income statement

Using the list of accounts below, construct a chart of accounts for a merchandising business that rents out a portion of its building, and assign account numbers and arranging the accounts in balance sheet and income statement order (“1” for assets, and so on). Each account number should have three digits. Contra accounts should be designated with a decimal of the account (100.1 for contra of account 100). Assets and liabilities should be in order of liquidity, expenses should be in alphabetical order.

Acc. No Description