### How much does cartwright need to borrow and when

Assignment Help Financial Management
##### Reference no: EM13865981

Case study: Cartwright Lumbeer Campany

Part -1:

Q1a Discuss how the interest expense (row 25) calculation works and whether or not it includes the short term borrowing on the Cartwright balance sheet. HINT: What is the source of the data used in the ratio on row 14?

Q1b How much does Cartwright need to borrow and when? Explain by citing specifics from the forecast.

Q1c Does Cartwright have the ability to pay the interest expense? Explain by citing specifics from the forecast.

Q1d Does Cartwright have the ability to repay the loan principal? Explain by citing specifics from the forecast.

Part -2:

Q2a Explain how the table from the Cohen Finance Workbook, shown above starting on row 47, works and its significance to Cartwright's (and most other businesses too) external financing needs problem.

Q2b Revise the short-form forecast model from Q1, using the 'input cells zeroed' model at the top of this tab.

As the banker, assume a lower growth rate in sales, and explain, showing specifics from the revised forecast, how it helps Cartwright solve his external financing needed problem. Enter revised data in the blue cells, using your judgment.

Verified Expert

#### What will your monthly payment be

You want to buy a new sports car from Muscle Motors for \$87,000. The contract is in the form of a 60-month annuity due at a 7.70 percent APR. What will your monthly payment be

#### Compute both the direct material cost and conversion cost

Victory Company uses weighted-average process costing to account for its production costs. Conversion cost is added evenly throughout the process. Direct materials are added a

#### What is the amount of the earnings before interest and taxes

Kwik Dogs is considering the installation of a new computerized pressure cooker that will cut annual operating costs by \$18,400. The system will cost \$42,900 to purchase and i

#### Calculate the weighted average cost of capital

Based on the information below, calculate the weighted average cost of capital. Great Corporation has the following capital situation.Debt: One thousand bonds were issued five

#### Doubts on the future growth of this company dividends

A company’s stock is currently worth \$50.00 per share based on a recent quarterly dividend of \$0.99 per share, expected quarterly growth of 1%, and a required rate of return o

#### What is your net profit on the transaction

You buy 100 CJC call option contracts with a strike price of 95 at a quoted price of \$1. At option expiration, CJC sells for \$97. What is your net profit on the transaction?

#### Calculate the amount of the firms gross profit

Evening story corporation has sales of 4523935; income tax of 448433;selling, general, and administrative expenses of 281882;depreciation of 347646;cost of goods sold of 27518

You are planning for your retirement and have decided the following: you will retire in 35 years and would like to have \$8,000 per month as retirement income for 30 years of r