Beg Yr 1 |
Beg Yr 2 |
Beg Yr 3 |
Beg Yr 4 |
Beg Yr 5 |
Beg Yr 6 |
Beg Yr 7 |
Beg Yr 8 |
Beg Yr 9 |
Beg Yr 10 |
End Yr 10 |
$1,000 |
$1,268 |
$1,426 |
$1,497 |
$1,579 |
$995 |
$1,258 |
$1,447 |
$1,478 |
$1,714 |
$2,270 |
What is your long-term geometric average? (the average at end of year 10
please show me how you calculated using excel
In: Finance
The most recent financial statements for Throwing Copper Co. are shown here: |
Income Statement | Balance Sheet | ||||
Sales | $50,000 | Current assets | $78,300 | Long-term debt | $54,000 |
Costs |
32,000 |
Fixed assets | 43,200 | Equity | 67,500 |
Taxable income | $18,000 | Total |
$121,500 |
Total |
$121,500 |
Taxes (34%) | 6,120 | ||||
Net income |
$11,880 |
||||
Assets and costs are proportional to sales. The company maintains a constant 20 percent dividend payout ratio and a constant debt−equity ratio. |
Required: |
What is the maximum increase in sales that can be sustained assuming no new equity is issued? (Do not round your intermediate calculations.) |
In: Finance
Which costs are relevant to Brad's decision to purchase a new, larger boat? If Brad decides to purchase a larger boat, what costs will be affected by this decision? Will they increase or decrease? Identify any unavoidable costs associated with the operation of Fishing Unlimited. Calculate the revenue generated by a 6-hour trip with the old boat (6 guests) and the new boat (8 guests) and compare the two figures. Identify the costs that changed. What conclusion can you draw based on your analysis? Brad Winston is the owner and operator of Fishing Unlimited, a charter fishing business operated out of Oregon Inlet, NC. Brad has been taking groups of guests offshore to fish for tuna and marlin for over 15 years. He purchased his current fishing boat when he started the business but now believes that a larger and better-outfitted vessel would allow him to increase the rate he charges per charter. Currently, he can carry a maximum of 6 guests while the larger boat will carry up to 8. The larger boat would also require him to take 2 deckhands on each outing, providing better service to his customers. Cost data for Brad's business is shown in the table below.
Fishing Unlimited Annual straight-line depreciation on boat$ 8,300
($175,000 original cost - $90,000 estimated resale value/20 years)
Fuel Cost (per hour)$ 50 Insurance Premium (annual)$ 1,900
Maintenance and Repairs (annual)$ 3,500
Fishing Tackle and Gear (original cost)$ 7,000
Tackle and Bait (per guest)$ 20
Deck Hand wages (per hour)$ 20
Dock Fees (annual)$ 2,400
Captain's License (annual)$ 200
Food and Beverages (per guest)$ 25
Professional Fees (per year)$ 750
Dock Utilities (annual)$ 1,200
Brad has someone interested in purchasing his existing boat for $80,000. He could use this cash as a deposit on the new boat which will cost him $225,000. His banker estimates the payments on the new boat will be about $1,500. The new boat is more fuel efficient and he believes he can cut his fuel costs by 10% but the more expensive boat will increase his insurance premium by 12%. He is also concerned that he will have to change to a larger boat slip which would increase his dock fees by 5%. The good thing about the new boat is that he should save on maintenance and repairs, at least for the first 3 years. The only other expense Brad would incur with the new boat is adding some additional fishing tackle and gear to accommodate larger parties that he estimates would cost him about $1,500.
His fees for both the old and the new boat are as follows: Old Boat 4 hours$ 550 6 hours$ 650 Full Day (9 hours)$ 1,100 New Boat 4 hours $ 600 6 hours $ 700 Full Day (9 hours) $1,200
In: Finance
Matta manufacturing is trying to decide between two different conveyor belt systems. System A costs $264,000, has a four year-life, and requires $81,000 in pretax annual operating costs. System B costs $372,000, has a six year life, and requires $75,000 in pretax annual operating costs. Both systems are to be depreciated straight-line to zero over their lives and will have zero salvage value. Whichever system is chosen, it will not be replaced when it wears out. The tax rate is 34 percent and the discount rate is 8 percent.
A/ Calculate the NPV for both conveyor belt systems
B/ Which conveyor belt system should the firm choose?
In: Finance
annual cash flow,
-500,000
125,000
150,000
175,000
200,000
250,000
What is the Modified IRR (MIRR), with a reinvestment rate equal to the WACC of 8%?
In: Finance
annual cash flow,
-500,000
125,000
150,000
175,000
200,000
250,000
What is the IRR of the investment
In: Finance
A borrower is offered a 30 year, fully amortizing ARM with an initial rate of 3.35%. After the first year, the interest rate will adjust each year, using 1 yr LIBOR as the index, plus a margin of 175bp. The price of the property is $8,000,000 and the loan will have an initial LTV ratio of 75% At the first reset date, 1 year LIBOR is at 3%. What is the borrower s payment during the 2nd year of the loan
In: Finance
A borrower is interested in comparing the monthly payments on two otherwise equivalent 30 year FRMs. Both loans are for $100,000 and have a 3.35% interest rate. Loan 1 is fully amortizing, where as Loan 2 has negative amortization with a $120,000 balloon payment due at the end of the life of the loan. How much higher is the monthly payment on loan 1 versus loan 2? (Hint: calculate both payments and take the difference. Only the future values of the loans are different. Round your answer to two decimal places.)
In: Finance
11: Sue owns 2000 shares of the 20 million outstanding common shares of ABC Corp. ABC stockholders have preemptive rights. Now, ABC decides to sell 2 million new common shares through a rights offering. How many rights will Sue receive?
a. 200
b. 0.20
c. 0.10
d. 20
18: Suppose we employ a "price-weighted" methodology to construct and track a two-stock index based on Stocks X and Y. Stock X has an initial price of $10 and there are 10 million shares outstanding. Stock Y has an initial price of $20 and there are 40 million shares outstanding. One month later, Stock Xs price is $12 and Stock Ys price is still $20. The shares outstanding remain the same. What is the percentage change in our price-weighted index over the one-month period?
a. 0
b. 20.00%
c. 6.67%
d. 2.22%
Display process
In: Finance
<6> You estimate that a passive portfolio invested to mimic the S&P 500 stock index yields an expected rate of return of 13% with a standard deviation of 25%. Draw the CML (capital market line) and your fund’s CAL on an expected return/standard-deviation diagram.
[NOTE: CML (capital market line) is a special case of the CAL; specifically, the risky portfolio in the CML line is a market portfolio. (In practice, we often use S&P 500 index as a proxy for the market portfolio.) ]
In: Finance
The technique for calculating a bid price can be extended to many other types of problems. Answer the following questions using the same technique as setting a bid price; that is, set the project NPV to zero and solve for the variable in question. Guthrie Enterprises needs someone to supply it with 159,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost $1,990,000 to install the equipment necessary to start production; you’ll depreciate this cost straight-line to zero over the project’s life. You estimate that in five years this equipment can be salvaged for $169,000. Your fixed production costs will be $284,000 per year, and your variable production costs should be $11.30 per carton. You also need an initial investment in net working capital of $149,000. The tax rate is 24 percent and you require a return of 13 percent on your investment. Assume that the price per carton is $17.90.
a. Calculate the project NPV. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
b. What is the minimum number of cartons per year that can be supplied and still break even? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)
c. What is the highest fixed costs that could be incurred and still break even? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
In: Finance
Question 2-7 are based on the following series of futures price (F(0), F(1),... F(6)):
Day 0: F(0)=$212
Day 1: F(1)=$211
Day 2: F(2)=$214
Day 3: F(3)=$209
Day 4: F(4)=$210
Day 5: F(5)=$202
Day 6: F(6)=$200
Suppose you are going to long 20 contracts. The initial margin=$10 per contract, and the maintenance margin is $2.
Questions:
How much do you need to deposit in the trading account at Day 0?
Using the same set of information from Question 2, what is the ending balance in Day 1?
Using the same set of information from Question 2, figure out what is the first day, on which, you receive margin call and need to put extra money into the trading account?
Using the same set of information from Question 2, answering what is the additional fund that needs to put into account on Day 6?
Using the same set of information from Question 2, answering what is the ending balance at Day 6?
Using the same set of information from Question 2, answering which day has the largest gain among the 6 days?
In: Finance
A firm is considering developing a Customer Relationship Management (CRM) system in order to better learn their customer’s preferences, and simplifying the ordering process. The firm is considering outsourcing the development to a well-known vendor. The vendor estimates the development cost to be $1 Million, which will be due upfront. The firm expects to generate additional revenues from better targeting of customers to the tune of $250,000 every year for the next ten years. The ongoing licensing and maintenance costs for the initiative is expected to be $25,000 annually. Assuming that the investment will be made in Year 0, and the annual benefits and costs will be incurred at the end of each year,
What is the Payback Period (rounded in years) for the project using discounted cash flows? What is the Return on Investment (again using discounted cash flows) for the project? What would be the Payback Period and the Return on Investment if the additional revenues were $200,000 annually instead of $250,000?
In: Finance
|
CROSBY, INC. 2017 Income Statement |
||||||
Sales | $ | 772,000 | ||||
Costs | 628,000 | |||||
Other expenses | 33,500 | |||||
Earnings before interest and taxes | $ | 110,500 | ||||
Interest paid | 17,600 | |||||
Taxable income | $ | 92,900 | ||||
Taxes (24%) | 22,296 | |||||
Net income | $ | 70,604 | ||||
Dividends | $ | 19,940 | ||||
Addition to retained earnings | 50,664 | |||||
CROSBY, INC. Balance Sheet as of December 31, 2017 |
|||||||
Assets | Liabilities and Owners’ Equity | ||||||
Current assets | Current liabilities | ||||||
Cash | $ | 26,140 | Accounts payable | $ | 65,000 | ||
Accounts receivable | 35,650 | Notes payable | 20,300 | ||||
Inventory | 72,230 | Total | $ | 85,300 | |||
Total | $ | 134,020 | Long-term debt | $ | 120,000 | ||
Owners’ equity | |||||||
Fixed assets | Common stock and paid-in surplus | $ | 115,000 | ||||
Net plant and equipment | $ | 229,000 | Retained earnings | 42,720 | |||
Total | $ | 157,720 | |||||
Total assets | $ | 363,020 | Total liabilities and owners’ equity | $ | 363,020 | ||
Complete the pro forma income statements below. (Input all answers as positive values. Do not round intermediate calculations.) |
Calculate the EFN for 20, 25 and 30 percent growth rates. (Do not round intermediate calculations. A negative answer should be indicated by a minus sign.) |
Next Visit question map
Question4of33Total4 of 33
Pre
In: Finance
Read Parts 1 and 2 of the article Morgan Stanley Round table on Capital Structure and Payout Policy and provide a summary of the salient points made by the panelists on the optimal capital structure and the payout policy of the firm
In: Finance