Question

In: Accounting

Revenues $300,000 Less operating expenses: Rent $169,000 Insurance 15,000 Depreciation 46,000 Maintenance 20,000 250,000 Net operating...

Revenues

$300,000

Less operating expenses:

Rent

$169,000

Insurance

15,000

Depreciation

46,000

Maintenance

20,000

250,000

Net operating income

$   50,000

1. A company has estimated the annual revenues and expenses for a project it is considering (listed above) that will cost a total of $500,000, have a ten-year useful life, and has a salvage value of $40,000. The company requires a payback period of 5 years or less.

  1. Using the information above, what is the expected annual cash flow for this company? ______________
  2. What is the payback period?    __________________________
    Would the company consider this project?   ______________
  3. What is the internal rate of return to the nearest percent?   _______________
  4. What is the simple rate of return promised by the project? _____________________________
    If the company requires a simple rate of return of at least 10%, will the games be purchased?    __________

Please show work

Solutions

Expert Solution

Solution a): Calculation of Expected Annual Cash flows of the company

Year

Net Operating Income

Depreciation

Expected Annual Cash Flows = Net Operating Income + Depreciation

1

                                  50,000.00

                             46,000.00

                        96,000.00

2

                                  50,000.00

                             46,000.00

                        96,000.00

3

                                  50,000.00

                             46,000.00

                        96,000.00

4

                                  50,000.00

                             46,000.00

                        96,000.00

5

                                  50,000.00

                             46,000.00

                        96,000.00

6

                                  50,000.00

                             46,000.00

                        96,000.00

7

                                  50,000.00

                             46,000.00

                        96,000.00

8

                                  50,000.00

                             46,000.00

                        96,000.00

9

                                  50,000.00

                             46,000.00

                        96,000.00

10

                                  50,000.00

                             46,000.00

                     1,36,000.00

Solution b) Calculation of Payback period:

Year

Net Operating Income

Depreciation

Expected Annual Cash Flows = Net Operating Income + Depreciation

Cumulative Expected Annual Cash Flows

1

                                  50,000.00

                             46,000.00

                        96,000.00

                96,000.00

2

                                  50,000.00

                             46,000.00

                        96,000.00

              1,92,000.00

3

                                  50,000.00

                            46,000.00

                        96,000.00

              2,88,000.00

4

                                  50,000.00

                             46,000.00

                        96,000.00

              3,84,000.00

5

                                  50,000.00

                             46,000.00

                        96,000.00

              4,80,000.00

6

                                  50,000.00

                             46,000.00

                        96,000.00

              5,76,000.00

7

                                  50,000.00

                             46,000.00

                        96,000.00

              6,72,000.00

8

                                  50,000.00

                             46,000.00

                        96,000.00

              7,68,000.00

9

                                  50,000.00

                             46,000.00

                        96,000.00

              8,64,000.00

10

                                  50,000.00

                             46,000.00

                     1,36,000.00

           10,00,000.00

As the Initial Investment is $500,000, the Payback period is between 5th and 6th Year.

PayBack Period                                   

= Completed Number of Years + (Cash Inflows to be recovered / Cash inflows for the next Year)

= 5 + (500,000 – 480,0000 / 96,000)

= 5.21 Years

The Payback period is 5.21 Years

As the company requires Payback period less than 5 years, the company should not consider this project.

Solution c) Calculation of Internal Rate of Return

Year

Cash Flows $

0

                            -5,00,000.00

1

                                  96,000.00

2

                                  96,000.00

3

                                  96,000.00

4

                                  96,000.00

5

                                  96,000.00

6

                                  96,000.00

7

                                  96,000.00

8

                                  96,000.00

9

                                  96,000.00

10

                              1,36,000.00

Following are the steps to be followed on Microsoft Excel to calculate the IRR:

Step 1: Click on "FORMULAS" tab at the top of Microsoft Excel
Step 2: Select the option "Financial"
Step 3: Under "Financial" select the option "IRR"
Step 4: Insert Values: (-500000;96000;96000;96000;96000;96000;96000;96000;96000;96000;136000)

IRR = 14.57%

The Internal Rate of Return is 14.57%


Solution d) Calculation of Simple Rate of Return

Simple Rate of Return = Average Net Income / Investment x 100

                                       = 50,000 / 500,000 x 100

                                       = 10%   


Simple Rate of Return for the Investment is 10%

If the company requires a simple rate of return of at least 10%, will the games be purchased?
Yes. The games should be purchased as the project is earning return of 10%


Related Solutions

A company has revenues of $450,000, cost of goods sold of $250,000, and operating expenses of...
A company has revenues of $450,000, cost of goods sold of $250,000, and operating expenses of $150,000. Its average current assets are $200,000 of which $75,000 is inventory and $20,000 are prepaid items. Of its liquid assets, 30 percent is cash and the remainder is accounts receivable. Its average total assets are $500,000 and its average total owners’ equity is $400,000. Seventy-five percent of its liabilities are current. Of the current liabilities, 80 percent is accounts payable. What are the...
The beginning balance of retained earnings plus net income (revenues less expenses), less dividends results in...
The beginning balance of retained earnings plus net income (revenues less expenses), less dividends results in the ending balance of retained earnings. At September 1, 2014, Five-O Inc. reported retained earnings of $136,000. During the month, Five-O generated revenues of $20,000, incurred expenses of $12,000, purchased equipment for $5,000 and paid dividends of $2,000. What is the balance in retained earnings at September 30, 2014? $8,000 credit $137,000 credit $142,000 credit $136,000 debit
1. If net revenues are 100,000 and advertising expenses are 20,000 what percentage would you get...
1. If net revenues are 100,000 and advertising expenses are 20,000 what percentage would you get for advertising if you were doing a vertical analysis? 2. If prior year cash was 100,000 and current year cash is 150,000 what would be the horizontal analysis calculation? 3. In the world of merchandising what is the equation to calculate cost of goods sold? 4. What makes up net purchases? 5. In manufacturing what are the differences in calculating cost of goods sold...
Champagne, Inc., had revenues of $14 million, cash operating expenses of $9.5 million, and depreciation and...
Champagne, Inc., had revenues of $14 million, cash operating expenses of $9.5 million, and depreciation and amortization of $1.6 million during 2018. The firm purchased $650,000 of equipment during the year while increasing its inventory by $450,000 (with no corresponding increase in current liabilities). The marginal tax rate for Champagne is 30 percent. What is Champagne's cash flow from operations for 2018? What is Champagne's free cash flow for 2018?
Strip Plank Parquet Total Sales revenue $400,000 $200,000 $300,000 $900,000 Less: Variable expenses 225,000 120,000 250,000...
Strip Plank Parquet Total Sales revenue $400,000 $200,000 $300,000 $900,000 Less: Variable expenses 225,000 120,000 250,000 595,000 Contribution margin $175,000 $ 80,000 $ 50,000 $305,000 Less direct fixed expenses:    Machine rent (5,000) (20,000) (30,000) (55,000)    Supervision (15,000) (10,000) (5,000) (30,000)    Depreciation (35,000) (10,000) (25,000) (70,000) Segment margin $120,000 $ 40,000 $ (10,000) $150,000 Hickory's management is deciding whether to keep or drop the parquet product line. Hickory's parquet flooring product line has a contribution margin of $50,000 (sales of $300,000...
An office complex has the following operating expenses in year one janitorial            $12,500 insurance           $13,500 maintenance  
An office complex has the following operating expenses in year one janitorial            $12,500 insurance           $13,500 maintenance      $14,050 property taxes   $8,651 landscaping       $8,248 The following tenants have agreed to reimburse for CAM expenses according to the following lease terms Office 1 (4,800 sq ft)    Up to $2.55 psf Office 2 (4,600 sq ft) Up to $2.70 psf Office 3 (4,300 sq ft) Up to $2.90 psf Office 4 (3,000 sq ft) Up to $3.15 psf Deli (1,500 sq ft) Up to...
Year 1 Year 2 Revenues 128.9 151.6 COGS and Operating Expenses (other than depreciation) 49.6 52.7...
Year 1 Year 2 Revenues 128.9 151.6 COGS and Operating Expenses (other than depreciation) 49.6 52.7 Depreciation 24.9 43.5 Increase in Net Working Capital 3.4 8.1 Capital Expenditures 27.3 43.2 Marginal Corporate Tax Rate 35% 35% a. What are the incremental earnings for this project for years 1 and​ 2?​ (Note: Assume any incremental cost of goods sold is included as part of operating​ expenses.) b. What are the free cash flows for this project for years 1 and​ 2?...
Year 1 Year 2 Revenues 120.8 150.6 COGS and Operating Expenses​ (other than​ depreciation) 46.1 54.5...
Year 1 Year 2 Revenues 120.8 150.6 COGS and Operating Expenses​ (other than​ depreciation) 46.1 54.5 Depreciation 24.9 32.9 Increase in Net Working Capital 2.8 8.2 Capital Expenditures 29.2 38.4 Marginal Corporate Tax Rate 35​% 35​% a. What are the incremental earnings for this project for years 1 and​ 2?​ (Note: Assume any incremental cost of goods sold is included as part of operating​ expenses.) b. What are the free cash flows for this project for years 1 and​ 2?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT