An underwriting firm such as Morgan Stanley or Goldman Sachs serves as the quarterback in an initial public offering (IPO). Its functions include providing advice to the issuing company (the issuer), underwriting the issue, and marketing the issue. Explain what those functions entail and, if you were the CFO of the issuing company, how you would assess the performance of the underwriting firm in carrying out its job?
In: Finance
Its an excel problem. Screenshots and actual work in excel is appreciated.
Suppose a company is about to start the following project, where all the dollar figures are in thousands of dollars. In year 0, the project requires a fixed cost of $12,000. The fixed costs is depreciated on the straight-line basis over five years, and there is a salvage value of $1,500 in year 5. The sales generated in years 1-5 are estimated to be 2,500 units, 3,200 units, 5,100 units, 3,400 units and 1,200 units. The costs of capital in year 1 is forecast to be 8.5% and decreases linearly by 0.2% for years 2 to 5, ending with 7.7% in year 5. The tax rate is forecast to be a constant 35.0%. Sales revenue per unit is forecast to be $8.50. Variable cost per unit is forecast to be $6.30. What is the project NPV? Develop your financial spreadsheet model with frozen panes for detailed calculations and name the worksheet “Project NPV”.
In: Finance
|
Consider a project to supply Detroit with 25,000 tons of machine screws annually for automobile production. You will need an initial $2,200,000 investment in threading equipment to get the project started; the project will last for 5 years. The accounting department estimates that annual fixed costs will be $700,000 and that variable costs should be $380 per ton; accounting will depreciate the initial fixed asset investment straight-line to zero over the 5-year project life. It also estimates a salvage value of $300,000 after dismantling costs. The marketing department estimates that the automakers will let the contract at a selling price of $480 per ton. The engineering department estimates you will need an initial net working capital investment of $220,000. You require a return of 12 percent and face a marginal tax rate of 22 percent on this project. |
| a-1 |
What is the estimated OCF for this project? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) |
| a-2 |
What is the estimated NPV for this project? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) |
| b. |
Suppose you believe that the accounting department’s initial cost and salvage value projections are accurate only to within ±15 percent; the marketing department’s price estimate is accurate only to within ±10 percent; and the engineering department’s net working capital estimate is accurate only to within ±5 percent. What is the worst-case NPV for this project? The best-case NPV? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) |
In: Finance
Has Sarbanes-Oxley been effective in mitigating auditor complicity in management frauds? Why, or why not?
In: Finance
In: Finance
Investment A
You are 25 years old, having just started working. You are considering a retirement plan for a retirement at the age of 65. You want to be able to withdraw $73,000 from your savings account on each birthday for 20 years following your retirement at the age of 65. Your first withdrawal will be on your 66th birthday. To achieve your goal, you intend to make equal annual deposits in a pension scheme which offers 7% interest per year.
According to the Investment A, you expect a lump sum of $ 100,000 from a family inheritance fund that you will receive on your 50th birthday. You will put this fund into the retirement savings account. Furthermore, you have invested in a portfolio what will be giving you $ 1,300 per year (from age 25 through age 65) which are to be added the retirement savings account as well.
If you begin making these deposits on your 25nd birthday and continue to make deposits until you are 65 (your last deposit will be made on your 65th birthday), what is the amount you are required to deposit annually to be able to make the desired withdrawals at retirement?
Investment B
Here you still have the same retirement plan in mind, in other words you want to be able to withdraw $73,000 from your savings account on each birthday for 20 years following your retirement at the age of 65. However, the investment criteria are different:
You have invested in a business which gives an annual net profit
of $ 2,300 per year.
Furthermore, your employer will contribute $ 550 to the account per
year as part of the company’s
profit-sharing plan starting from age 45 to 65. What amount must you deposit annually now to be able to make the desired withdrawals at retirement? Which investment will you choose and why?
In: Finance
HW2: Interest Rate Parity with bid-ask spreads
Suppose:
Spot rate St = $1.5080 - $1.5095 / £
Six month Forward rate Ft,t+6 = $1.5280 – 1.5292/£
Interest rate in US = 4.6% – 4.8%
Interest rate in UK = 3.0% – 3.3%
With bid-ask rates and borrowing-lending rates, is arbitrage profit possible if you start with $1 million in part (a) and £ 1 million in part (b) ? Do it both ways :
(a) borrow $ 1 million in US and invest overseas and
(b) borrow £ 1 million in UK and invest in US.
In: Finance
XYZ used an investment bank to do IPO. In IPO, XYZ sold 1 million shares at $66.52 each. The investment bank charged 7% spread. At the end of the 1st day of trading, XYZ stock price closed at $72.63. Calculate the total cost of IPO. That is, what is the sum of direct and indirect cost?
In: Finance
Dana Company projects a sales revenue of $150,000 during the calendar year 2014. Using the income statement provided below, prepare a pro-forma income statement using the percent-of-sales method.
Income Statement
Dana Dairy Products
For the Year Ended December 31, 2013
| Sales Revenue | 100,000 |
| Less: Cost of Good Sold | 87,000 |
| Gross Profits | 13,000 |
| Less: Operating Expenses | 11,000 |
| Operating Profits | 2,000 |
| Less: Interest Expense | 500 |
| Net Profits before taxes | 1500 |
| Less: Taxes (40%) | 600 |
| Net Profits after taxes | 900 |
In: Finance
|
ANNUAL BALANCE SHEET |
||||||
|
($ MILLIONS) |
||||||
|
BOEING CO |
||||||
|
Dec09 |
Dec08 |
Dec07 |
Dec06 |
Dec05 |
||
|
ASSETS |
||||||
|
Cash & Short-Term Investments |
11,223 |
3,279 |
9,308 |
6,386 |
5,966 |
|
|
Net Receivables |
6,153 |
6,027 |
6,068 |
5,655 |
5,613 |
|
|
Inventories |
16,933 |
15,612 |
9,563 |
8,105 |
7,940 |
|
|
Other Current Assets |
966 |
1,046 |
2,341 |
2,837 |
2,449 |
|
|
------------------ |
------------------ |
------------------ |
------------------ |
-------------- |
||
|
Total Current Assets |
35,275 |
25,964 |
27,280 |
22,983 |
21,968 |
|
|
Gross Plant, Property & Equipment |
21,579 |
21,042 |
20,180 |
19,310 |
19,692 |
|
|
Accumulated Depreciation |
12,795 |
12,280 |
11,915 |
11,635 |
11,272 |
|
|
------------------ |
------------------ |
------------------ |
------------------ |
-------------- |
||
|
Net Plant, Property & Equipment |
8,784 |
8,762 |
8,265 |
7,675 |
8,420 |
|
|
Investments at Equity |
974 |
942 |
1,085 |
964 |
84 |
|
|
Other Investments |
5,522 |
6,243 |
9,803 |
11,641 |
12,407 |
|
|
Intangibles |
7,196 |
6,332 |
5,174 |
4,745 |
2,799 |
|
|
Deferred Charges |
- |
- |
- |
- |
13,251 |
|
|
Other Assets |
4,302 |
5,536 |
7,379 |
3,786 |
1,129 |
|
|
------------------ |
------------------ |
------------------ |
------------------ |
-------------- |
||
|
TOTAL ASSETS |
62,053 |
53,779 |
58,986 |
51,794 |
60,058 |
|
|
LIABILITIES |
||||||
|
Long Term Debt Due In One Year |
707 |
560 |
762 |
1,381 |
1,189 |
|
|
Accounts Payable |
7,096 |
5,871 |
5,714 |
5,643 |
5,124 |
|
|
Taxes Payable |
182 |
41 |
253 |
670 |
556 |
|
|
Accrued Expenses |
12,822 |
6,169 |
6,637 |
6,106 |
6,590 |
|
|
Other Current Liabilities |
12,076 |
18,284 |
18,172 |
15,901 |
14,729 |
|
|
------------------ |
------------------ |
------------------ |
------------------ |
-------------- |
||
|
Total Current Liabilities |
32,883 |
30,925 |
31,538 |
29,701 |
28,188 |
|
|
Long Term Debt |
12,217 |
6,952 |
7,455 |
8,157 |
9,538 |
|
|
Deferred Taxes |
- |
- |
1,190 |
- |
2,067 |
|
|
Minority Interest |
97 |
|||||
|
Other Liabilities |
14,728 |
17,196 |
9,799 |
9,197 |
9,206 |
|
|
------------------ |
------------------ |
------------------ |
------------------ |
-------------- |
||
|
TOTAL LIABILITIES |
59,925 |
55,073 |
49,982 |
47,055 |
48,999 |
|
|
EQUITY |
||||||
|
Common Stock |
5,061 |
5,061 |
5,061 |
5,061 |
5,061 |
|
|
Capital Surplus |
3,724 |
3,456 |
4,757 |
4,655 |
4,371 |
|
|
Retained Earnings |
10,869 |
9,150 |
16,780 |
10,236 |
15,498 |
|
|
Less: Treasury Stock |
17,526 |
18,961 |
17,594 |
15,213 |
13,871 |
|
|
------------------ |
------------------ |
------------------ |
------------------ |
-------------- |
||
|
TOTAL EQUITY |
2,128 |
(1,294) |
9,004 |
4,739 |
11,059 |
|
|
------------------ |
------------------ |
------------------ |
------------------ |
-------------- |
||
|
TOTAL LIABILITIES & EQUITY |
62,053 |
53,779 |
58,986 |
51,794 |
60,058 |
|
|
Common Shares Outstanding |
726.291 |
698.138 |
736.681 |
757.836 |
760.577 |
|
|
ANNUAL INCOME STATEMENT |
||||||
|
Dec09 |
Dec08 |
Dec07 |
Dec06 |
Dec05 |
||
|
Sales |
68,281 |
60,909 |
66,387 |
61,530 |
54,845 |
|
|
Cost of Goods Sold |
55,092 |
48,950 |
51,977 |
48,926 |
44,757 |
|
|
------------------- |
------------------ |
------------------ |
------------------ |
--------------- |
||
|
Gross Profit |
13,189 |
11,959 |
14,410 |
12,604 |
10,088 |
|
|
Selling, General, & Administrative Exp. |
9,870 |
6,852 |
7,381 |
7,428 |
6,433 |
|
|
------------------- |
------------------ |
------------------ |
------------------ |
--------------- |
||
|
Operating Income Before Deprec. |
3,319 |
5,107 |
7,029 |
5,176 |
3,655 |
|
|
Depreciation,Depletion,&Amortization |
1,273 |
1,179 |
1,130 |
1,158 |
1,092 |
|
|
------------------- |
------------------ |
------------------ |
------------------ |
--------------- |
||
|
Operating Profit |
2,046 |
3,928 |
5,899 |
4,018 |
2,563 |
|
|
Interest Expense |
604 |
524 |
608 |
657 |
713 |
|
|
Non-Operating Income/Expense |
289 |
591 |
827 |
709 |
391 |
|
|
Special Items |
(876) |
578 |
||||
|
------------------- |
------------------ |
------------------ |
------------------ |
--------------- |
||
|
Pretax Income |
1,731 |
3,995 |
6,118 |
3,194 |
2,819 |
|
|
Total Income Taxes |
396 |
1,341 |
2,060 |
988 |
257 |
|
|
------------------- |
------------------ |
------------------ |
------------------ |
--------------- |
||
|
Income Before Extraordinary |
||||||
|
Items & Discontinued Operations |
1,335 |
2,654 |
4,058 |
2,206 |
2,562 |
|
|
Discontinued Operations |
(23) |
18 |
16 |
9 |
(7) |
|
|
------------------- |
------------------ |
------------------ |
------------------ |
--------------- |
||
|
Adjusted Net Income |
1,312 |
2,672 |
4,074 |
2,215 |
2,555 |
|
|
A. What percentage decline in earnings before interest and taxes could Boeing have sustained in these years before failing to cover |
||||
|
i. Interest and principal repayment requirements, |
||||
|
ii. Interest, principal and common dividend payments? |
||||
|
B. What do these calculations suggest about Boeing’s financial leverage during this period? |
||||
Please Answer question in detailed and as soon as possible. Thank you!
In: Finance
Compute the payback period, Internal Rate of Return and Net. Present Value. Assume a Discount Rate of 4%, Ivt. in Project is $1,500,000 Year Return ($) 1 300k 2 500k 3 400k 4 300k 5 200k 6 100k
In: Finance
n = 35 yrs
PV = 50,000
PMT = 15,000
I = 8%
FV in 35 years = ?
FV if I is 3% = ?
In: Finance
You are 20 years old. You plan to work until you are 80 years old. When you turn 80 you will retire. You expect to live until an age of 95. You have forecasted that you will need $50,000 a year in income for your retirement.Your current salary is $45,000 per year. You expect your salary to grow by 0% per year.You will save 5% of your gross income each year.You will invest your savings in risk free treasury notes that are expected to yield 3% each year.Based on this information you will have accumulated enough wealth to finance your retirement.
True or False?
In: Finance
ABCD Inc. manufactures financial calculators. The company is deciding whether to introduce a new calculator. This calculator will sell for $100. The company feels that sales will be 12,500, 13,000, 14,000, 13,200, and 12,500 units per year for the next 5 years. Variable costs will be 25% of sales, and fixed costs are $300,000 per year. The firm hired a marketing team to analyze the viability of the product and the marketing analysis cost $1,500,000. The company plans to use a vacant warehouse to manufacture and store the calculators. Based on a recent appraisal the warehouse and the property is worth $2.5 million on an after-tax basis. If the company does not sell the property today then it will sell the property 5 years from today at the currently appraised value. This project will require an injection of net working capital at the onset of the project in the amount of $100,000. This networking capital will be fully recovered at the end of the project. The firm will need to purchase some equipment in the amount of $1,200,000 to produce the new calculators. The machine has a 7-year life and will be depreciated using the straight-line method. At the end of the project, the anticipated market value of the machine is $150,000. The firm requires a 10% return on its investment and has a tax rate of 21%.
Calculate the book value of the machine at the end of year 5
Calculate the depreciation expense at the end of year 2
Calculate the after tax salvage value at the end of year 5
Calculate the cash flow from assets at the end of year 5
Calculate the net present value for the project
Round to two decimals
In: Finance
Problem #5: A loan of $44,000 is paid off in 36 payments at the end of each month in the following way: Payments of $1100 are made at the end of the month for the first 12 months. Payments of $1100 + x are made at the end of the month for the second 12 months. Payments of $1100 + 2x are made at the end of the month for the last 12 months. What should x be if the nominal monthly rate is 12.4%?
In: Finance