Questions
On September 7​, the billing​ date, Verna had a balance due of ​$565.85 on her credit...

On September 7​, the billing​ date, Verna had a balance due of ​$565.85 on her credit card. Assume that the interest rate is​ 1.1% per month. Suppose that​ Verna's bank uses the average daily balance method. Answer parts​ (a) through​ (d). Sept. 11 Payment ​$280.00 Sept. 23 ​Charge: Airline ticket ​$332.00 Sept. 24 ​Charge: Hotel bill ​$190.01 Oct. 2 ​Charge: Clothing ​$84.91 ​a) Determine​ Verna's average daily balance for the billing period from September 7 to October 7. The average daily balance for the billing period was ​$

In: Finance

Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them...

Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them set up their new computers. Upton's balance sheet as of December 31, 2016, is shown here (millions of dollars):

Cash $   3.5 Accounts payable $   9.0
Receivables 26.0 Notes payable 18.0
Inventories 58.0 Line of credit 0
Total current assets $ 87.5 Accruals 8.5
Net fixed assets 35.0 Total current liabilities $ 35.5
Mortgage loan 6.0
Common stock 15.0
Retained earnings 66.0
Total assets $122.5 Total liabilities and equity $122.5

Sales for 2016 were $200 million and net income for the year was $6 million, so the firm's profit margin was 3.0%. Upton paid dividends of $2.4 million to common stockholders, so its payout ratio was 40%. Its tax rate was 40%, and it operated at full capacity. Assume that all assets/sales ratios, (spontaneous liabilities)/sales ratios, the profit margin, and the payout ratio remain constant in 2017. Do not round intermediate calculations.

  1. If sales are projected to increase by $100 million, or 50%, during 2017, use the AFN equation to determine Upton's projected external capital requirements. Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answer to two decimal places.
    $ million
  2. Using the AFN equation, determine Upton's self-supporting growth rate. That is, what is the maximum growth rate the firm can achieve without having to employ nonspontaneous external funds? Round your answer to two decimal places.
    %
  3. Use the forecasted financial statement method to forecast Upton's balance sheet for December 31, 2017. Assume that all additional external capital is raised as a line of credit at the end of the year and is reflected (because the debt is added at the end of the year, there will be no additional interest expense due to the new debt).
    Assume Upton's profit margin and dividend payout ratio will be the same in 2017 as they were in 2016. What is the amount of the line of credit reported on the 2017 forecasted balance sheets? (Hint: You don't need to forecast the income statements because the line of credit is taken out on last day of the year and you are given the projected sales, profit margin, and dividend payout ratio; these figures allow you to calculate the 2017 addition to retained earnings for the balance sheet without actually constructing a full income statement.) Round your answers to the nearest cent.
    Upton Computers
    Pro Forma Balance Sheet
    December 31, 2017
    (Millions of Dollars)
    Cash $
    Receivables $
    Inventories $
    Total current assets $
    Net fixed assets $
    Total assets $
    Accounts payable $
    Notes payable $
    Line of credit $  
    Accruals $
    Total current liabilities $
    Mortgage loan $
    Common stock $
    Retained earnings $
    Total liabilities and equity $

In: Finance

5. Easton Company prepares annual adjusting entries only. During the third quarter of Fiscal Year 2018,...

5.

Easton Company prepares annual adjusting entries only. During the third quarter of Fiscal Year 2018, Easton Company acquired the following trading securities:

Date

Company

# of Shares

Price per Share

8/15

X Company

1,500

$46

9/25

Y Company

1,250

30

9/30

Z Company

1,000

22

On November 10th, Easton Company sold the Y Company stock for $31 per share. On December 15th, Z Company paid dividends of $0.12 per share. The following were the year-end market values:

Company

FMV per Share

X Company

$51

Y Company

15

Z Company

25

What the total dollar values that Easton Company should record for the Unrealized Gain or (Loss) on Trading Securities for 2018? Enter a Loss as a negative number.

6.

Arundel Company uses aging to estimate uncollectibles.  At the end of the fiscal year, December 31, 2018, Accounts Receivable has a balance that consists of:

Dollar Value

Age of Account

Estimated Collectible

$235,000

< 30 days old

98.0%

60,000

30 to 60 days old

95.0%

25,000

61 to 120 days old

77.0%

6,000

> 120 days old

17.0%

The current unadjusted Allowance for Uncollectible Accounts balance is a debit balance of $2,000 and the Bad Debt Expense accounts has an unadjusted balance of zero. After the adjusting entry is made, what will be the dollar balances in the Allowance for Doubtful Accounts? Round to nearest whole dollar.

In: Finance

NPVs and IRRs for Mutually Exclusive Projects Davis Industries must choose between a gas-powered and an...

NPVs and IRRs for Mutually Exclusive Projects

Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate; it will cost $21,500, whereas the gas-powered truck will cost $17,960. The cost of capital that applies to both investments is 13%. The life for both types of truck is estimated to be 6 years, during which time the net cash flows for the electric-powered truck will be $6,860 per year and those for the gas-powered truck will be $4,600 per year. Annual net cash flows include depreciation expenses.

Calculate the NPV for each type of truck. Do not round intermediate calculations. Round your answers to the nearest dollar.

Electric-powered truck $
Gas-powered truck

$

Calculate the IRR for each type of truck. Do not round intermediate calculations. Round your answers to two decimal places.

Electric-powered truck %
Gas-powered truck %

Not getting the correct answers with excel functions for some reason.

In: Finance

A real estate investment has the following expected cash flows:                         Year       

A real estate investment has the following expected cash flows:

                        Year           Cash Flows
                          1              $9,000
                          2               13,000
                          3               18,000
                          4               25,000

The discount rate is 12 percent. What is the investment’s present value? Round your answer to 2 decimal places; for example 2345.25.

In: Finance

Financing Deficit Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as of December...

Financing Deficit

Garlington Technologies Inc.'s 2016 financial statements are shown below:

Balance Sheet as of December 31, 2016

Cash $   180,000 Accounts payable $   360,000
Receivables 360,000 Notes payable 156,000
Inventories 720,000 Line of credit 0
Total current assets $1,260,000 Accruals 180,000
Fixed assets 1,440,000 Total current liabilities $   696,000
Common stock 1,800,000
Retained earnings 204,000
Total assets $2,700,000 Total liabilities and equity $2,700,000

Income Statement for December 31, 2016

Sales $3,600,000
Operating costs 3,279,720
EBIT $  320,280
Interest 18,280
Pre-tax earnings $  302,000
Taxes (40%) 120,800
Net income 181,200
Dividends $  108,000

Suppose that in 2017 sales increase by 5% over 2016 sales and that 2017 dividends will increase to $144,000. Forecast the financial statements using the forecasted financial statement method. Assume the firm operated at full capacity in 2016. Use an interest rate of 8%, and assume that any new debt will be added at the end of the year (so forecast the interest expense based on the debt balance at the beginning of the year). Cash does not earn any interest income. Assume that the all new-debt will be in the form of a line of credit. Round your answers to the nearest dollar. Do not round intermediate calculations.

Garlington Technologies Inc.
Pro Forma Income Statement
December 31, 2017
Sales $
Operating costs $
EBIT $
Interest $
Pre-tax earnings $
Taxes (40%) $
Net income $
Dividends: $
Addition to RE: $
Garlington Technologies Inc.
Pro Forma Balance Statement
December 31, 2017
Cash $
Receivables $
Inventories $
Total current assets $
Fixed assets $
Total assets $
Accounts payable $
Notes payable $
Accruals $
Total current liabilities $
Common stock $
Retained earnings $
Total liabilities and equity $

In: Finance

Micheal wants to have $68,000 in 10 years on a savings plan that requires monthly contributions....

Micheal wants to have $68,000 in 10 years on a savings plan that requires monthly contributions. If he can earn 11 percent APR with monthly compounding on the savings plan, what is the amount that he will have to invest every month for the next 10 years? Round it to two decimal places and do not include the $ sign, e.g., 1234.56.

In: Finance

1.A firm is buying a new machine that has the following cash-flows during its expected life...

1.A firm is buying a new machine that has the following cash-flows during its expected life of 4 years: Purchase Price = $250,000, Terminal Value = $100,000, and yearly cash flows of $60,000. The firm has a contract with a buyer who purchases and pays the product that the machine makes at the beginning of each year. What is the expected yield of the machine? a. 28% b. 16% c. 14% d. 11.3% e. -1.61

2.A firm wants to buy a machine that is expected to yield 12%. It plans to finance it with 50% Debt and the rest Equity, so there is no preferred stock. The cost of Debt is 7% and the tax rate is 25%. What is the expected return for the shareholders?

a.   2.63%

b.   12%

c.   17%

d.   18.75%

e.   19.5%

3.Which of the following statements is CORRECT?

a.   Financial Management decisions have to be made taking into account what is available on the Financial Markets.

b.   Only firms in the mature stage have access to the capital market.

c.   If an investor sells shares of stock through a broker, then it would be a primary market transaction.

d.   Capital markets deal only with common stocks and other equity securities.

e.   A six-month bank loan is considered to be a capital market instrument.

In: Finance

When engaging in capital budgeting projects, what types of risk may exist? What are some techniques...

When engaging in capital budgeting projects, what types of risk may exist? What are some techniques you could use to evaluate and/or mitigate those risks.

In: Finance

You are negotiating to buy a new car with a car salesman at a local dealer....

You are negotiating to buy a new car with a car salesman at a local dealer. You have negotiated the price to $31,000. You have $3,000 to put towards the down payment and plan to get a loan for the rest. If you can get an annual interest rate of 5 percent APR (with monthly compounding) over a 5-year period, what would be your monthly payment? Round it to two decimal place (cents)

In: Finance

In February, Cap Inc. announced that it would split into two independent publicly traded companies: one...

In February, Cap Inc. announced that it would split into two independent publicly traded companies: one comprised of its Old Navy brand, and the second a yet-to-be-named company that includes its other brands like Banana Republic and Athleta. The planned breakup is an acknowledgment of the two chains' diverging fortunes and how much Gap has lost its once-powerful grip on American consumers. For several years, Old Navy has outperformed its sister brands Gap and Banana Republic with its lower price-points and catchy marketing. Old Navy now exceeds the original brand in sales, making up nearly half of Gap Inc.'s $16.6 billion of sales in 2018.

In your opinion, what are the benefits and downsides to splitting Gap into two firms? How did Gap's stock react to the news in after-market trading? How would you explain this reaction? Will the separation save the company in the long run? Please elaborate on your answers.

In: Finance

Hewlett Packard recently paid a dividend of $2.50 for 2016, and going forward, their dividend is...

Hewlett Packard recently paid a dividend of $2.50 for 2016, and going forward, their dividend is expected to grow at 3 percent per year for the next 5 years, after which the dividend growth rate will increase to 6 percent per year indefinitely. Assuming a 10 percent required rate of return, compute that value of a share of common stock for HP.

In: Finance

(Weighted average cost of capital​) The capital structure for the Carion Corporation is provided​ here:The company...

(Weighted average cost of capital​) The capital structure for the Carion Corporation is provided​ here:The company plans to maintain its debt structure in the future. If the firm has an​ after-tax cost of debt of 5.3 ​percent, a cost of preferred stock of 13.5 ​percent, and a cost of common stock of 18.6 ​percent, what is the​ firm's weighted average cost of​ capital?

CAPITAL STRUCTURE​ ($000)

Bonds

​$1,095

Preferred stock

279

Common stock

3,633

​$5,007

In: Finance

​(Cost of debt​) Sincere Stationery Corporation needs to raise ​$750,000 to improve its manufacturing plant. It...

​(Cost of debt​) Sincere Stationery Corporation needs to raise ​$750,000 to improve its manufacturing plant. It has decided to issue a ​$1,000 par value bond with an annual coupon rate of 16 percent and a maturity of 15 years. The investors require a rate of return of 8 percent.

a. Compute the market value of the bonds.

b. What will the net price be if flotation costs are

1111

percent of the market​ price?

c. How many bonds will the firm have to issue to receive the needed​ funds?

d. What is the​ firm's after-tax cost of debt if its average tax rate is 25 percent and its marginal tax rate is

3737

​percent?

In: Finance

Presentation graphics prepare slides and other aids for individuals making presentations. it estimates it can save...

Presentation graphics prepare slides and other aids for individuals making presentations. it estimates it can save $42,000 a year in cash operating costs for the next 5 years if it buys a special machine at a cost of $90,000. the workstation qualifies for a capital cost allowance of 25% and will have a zero terminal disposal price at the end of year 5. Presentation and graphics has a 12% after-tax required rate of return. its income tax rate is 40% each year for the next 5 years.

Compute NPV, Payback period, IRR (BA II plus Financial Calculator can be used, if you could just show what numbers were keyed) thank you

In: Finance