Calculate the maximum investment in property

Reference no: EM13932933

Question 1

Huskers Inc. is told by its bank that Huskers Inc. can at most have $16,000 balance on its bank debt account next year. Given this constraint, calculate the maximum investment in property, plant and equipment that Huskers Inc. can make during 2013. To answer this question, use the following assumptions:

- Annual sales growth will be 10% during the next year.

- Annual COGS will be 73.5% of the annual revenues.

- Depreciation expense will be 10% of gross PP&E.

- Interest rate is 10% and the annual interest expense is computed as 10% of the previous year's interest bearing debt balance (interest bearing debt =

bank debt + long-term debt)

- Company will not pay any dividends during the next year.

- Cash balance will be 20% of the annual revenue.

- Accounts receivable will be 60% of the annual revenue.

- Accounts payable will be 60% of the annual revenue.

- Long-term debt balance will remain at $20,000 during the next two years.

- Company will not issue equity during the next year.

Income Statement

2012 2013

Revenue $50,000 $55,000.00 [2]

COGS (Excludes depreciation expense) $36,750 $40,425.00 [3]

Depreciation expense $5,000 0.1*(50,000+x) [4]

EBIT $8,250 =55,000-40,425-0.1*(50,000+x) [5]

Interest expense

(10% of previous year's interest bearing debt balance) $2,000 2000 [6]

EBT $6,250 =12,575-0.1*(50,000+x)

=7575-0.1x [7]

Taxes (20%) $1,250 =0.2*(7575-0.1x) [8]

Net income $5,000 =0.8*(7575-0.1x)

=6060-0.08x [9]

Dividends 0 0

- Balance Sheet

Assume that the investment in GPPE is represented by x and fill up the rest of the balance sheet. Numbers in the brackets show the sequence in which I

filled the BS. The sum of L&E must be 79,000 +0.9x. Therefore we have:

33,000+16,000+20,000+20,000+16,060-0.08x = 79,000+0.9x

x = $26.591.84

Assets 2011 2012 2013

Cash $8,000 $10,000 $11,000.00 [10]

Accounts receivable $12,000 $30,000 $33,000.00 [11]

Gross PP&E $50,000 $50,000 50,000+x [1]

Less accumulated depreciation $5,000 $10,000 10,000+0.1*(50,000+x) [12]

Net PP&E $45,000 $40,000 =0.9*(50,000+x)-10,000 [13]

Total assets $65,000 $80,000 =11,000+33,000+0.9*(50,000+x)-10,000

=79,000+0.9x [14]

Liabilities and Equity

Accounts payable $20,000 $30,000 33,000 [16]

Bank debt 0 0 16,000 [17]

Long-term debt $20,000 $20,000 20,000 [18]

Common equity $20,000 $20,000 20,000 [19]

Retained earnings $5,000 $10,000 10,000+6060-0.08x

=16060-0.08x [20]

Total L+E $65,000 $80,000 =79,000+0.9x [1

Assume that the investment in GPPE is represented by x and fill up the rest of the balance sheet. Numbers in the brackets show the sequence in which I filled the BS. The sum of L&E must be 79,000 +0.9x. Therefore we have:

33,000+16,000+20,000+20,000+16,060-0.08x = 79,000+0.9x x = $26.591.84

Reference no: EM13932933

Questions Cloud

Describe the simulation and estimate the probability : Develop a simulation for finding the probability that when 50 people are randomly selected, at least three of them have the same birth date. Describe the simulation and estimate the probability.

Identifies a key principle of reengineering : A Responsibility Chart specifically identifies which of the following? Which of the following identifies a key principle of Reengineering

Purchasing power parity theory : Discuss how the Purchasing Power Parity theory affects the investment decisions of (i) informed investors, and (ii) multinational firms that invest in major emerging countries such as China and India.

How does light and color in indoor work environment impact : How does light and color in indoor work environment impact psychological functioning? Is this a cross-cultural effect?

Calculate the maximum investment in property : Huskers Inc. is told by its bank that Huskers Inc. can at most have $16,000 balance on its bank debt account next year. Given this constraint, calculate the maximum investment in property, plant and equipment that Huskers Inc. can make during 2013..

Fundamental objective of the land registration act : The fundamental objective of the Land Registration Act is that "under the system of electronic dealing with land that it seeks to create, the register should be a complete and accurate reflection of the state of the title of the land at any given ..

Analytical processes and decision making techniques : The course covers analytical processes and decision making techniques for sound investment and credit decisions. Students will learn how to read financial statements and extract information to assess profitability risk accounting quality anf valua..

What is the area of the leaf : What is the area (in m2) of the leaf? (b) If, instead, the gold is drawn out into a cylindrical fiber of radius 2.900 ?m, what is the length (in m) of the fiber?

Policies implemented the eus principles of flexicurity : Explain how Germany OR Denmark has sought to have both some elements of security and flexibility in their labour markets. How far have these policies implemented the EUs principles of flexicurity?

User Account

All Pages