1. Seth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority, the company's geologist, has just finished his analysis of the mine site. He has estimated that the mine would be productive for eight years, after which the gold would be completely mined. Dan has taken an estimate of the gold deposits to Alma Garrett, the company's financial officer. Alma has been asked by Seth to perform an analysis of the new mine and present her recommendation on whether the company should open the new mine.
Alma has used the estimates provided by Dan to determine the revenues that could be expected from the mine. She has also projected the expense of opening the mine and the annual operating expenses. If the company opens the mine, it will cost $635 million today, and it will have a cash outflow of $45 million nine years from today in costs associated with closing the mine and reclaiming the area surrounding it. The expected cash flows each year from the mine are shown in the table. Bullock Mining has a 12 percent required return on all of its gold mines.
| Year | Cashflow |
| 0 | -635,000,000 |
| 1 | 89,000,000 |
| 2 | 105,000,000 |
| 3 | 130,000,000 |
| 4 | 173,000,000 |
| 5 | 205,000,000 |
| 6 | 155,000,000 |
| 7 | 145,000,000 |
| 8 | 122,000,000 |
| 9 | -45,000,000 |
Questions:
1. Construct a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return, and the net present value of the proposed mine.
2. Based on your analysis, should the company open the mine?
3. Bonus question: Most spreadsheets does not have a built-in formula to calculate the payback period. Write a VBA script that calculates the payback period for a project.
Change the cash-flows as follows
Investment: 600,000,000
| Year | Cashflow |
| 1 | 79,000,000 |
| 2 | 95,000,000 |
| 3 | 120,000,000 |
| 4 | 163,000,000 |
| 5 | 195,000,000 |
| 6 | 145,000,000 |
| 7 | 135,000,000 |
| 8 | 112,000,000 |
| 9 | -55,000,000 |
B. Answer the same question from problem 1
In: Finance
Case Study- A
National Foodservice Equipment Pty Ltd is a Western Australian company. Within the hospitality and catering industry, National Foodservice Equipment is recognised as a leading supplier and distributor to the foodservice sector. The business started in 1999 and has grown to 24 employees, with locations in Perth and Busselton.
National Foodservice Equipment needed to find a solution that could cater for multi warehousing and deliver adequate stock control. In short, they had simply outgrown their current systems and felt the previous software they were using could no longer meet the company’s growing needs. As a long term user of MYOB Premier and another third party custom built system, it meant that the integration of the two systems was critical for success.
The Finance and Administration Manager, Simon Phipps project managed the assessment, selection, specification and implementation of MYOB Exonet as National Foodservice Equipment’s business management system of choice. He also had a solid hand in configuring many of the business’s reports. It was showcased as the next step up from MYOB Premier and a logical choice for the business. According to Simon, “it was the association with MYOB that sold the product.” The integrated stock handling system of MYOB Exonet also appealed to the needs of National Foodservice Equipment. Each stock item can include codes, descriptions, groups, cost & sell prices, tracking methods and stock levels for each location.
Questions
In: Computer Science
TUV Hardware Stores is a major retailer of lumber and building products. They are privately owned but professionally managed. Recently, they took out a bank loan to build a new robotic warehouse. Debt to equity is now .2:1, and the bank has asked for financial statements. They have approached your audit firm to provide some assurance based on your excellent reputation.
Each retail store is franchised and there are no corporate-owned stores. In 2020, franchise fees are expected to be $176 million while wholesale sales to stores are expected to be $2,416 million and wholesale sales direct to major builders are expected to be $203 million. Gross profit on wholesale sales is around 5%. The franchise fee goes to such things as store support (training, point of sale inventory, pricing systems) and advertising, and a 20% profit.
TUV has operations across Canada with major warehouses in Vancouver, Winnipeg, Brampton, and St. John, New Brunswick. The new warehouse will be built in Kitchener. When it is complete, the warehouse in Brampton will be sold, likely for a large gain on sale since land prices in Brampton have soared in the last few years.
Required
Briefly discuss five elements to consider in planning the engagement for TUV.
In: Finance
Case analysis # 2 - Siwek took his new Buick to his dealer for minor repairs.
While the car was in the dealer's repair shop, the dealer informed Siwek that the car was equipped with a Chevrolet engine. The standard engine for a car of the model and year in question was a 2.4 litre 4-cylinder manufactured by the Buick division of General Motors. Before the introduction of the year's models, the manufacturer determined that there would not be enough engines built to equip all the Buick models manufactured. For this reason, it was decided to install Chevrolet engines in some Buick cars without disclosing the practice to the buyers.
Siwek complained to the Illinois attorney general, who filed a class-action suit against General Motors charging that GM deceived consumers by not informing them of the engine switch. This case presents both ethical and legal principles.
(i) Please discuss the principles that you think are relevant in this case.
(ii) Does New York have any laws addressing deceptive consumer practices? If so, please cite to the specific laws and summarize them,
(iii) please discuss what, if anything, you would do if you were General Motors and had to defend this case to keep your business alive.
In: Economics
1- Which of the following statements is NOT true?
Basic shares outstanding are always included in fully diluted shares outstanding.
Fully diluted shares outstanding include all potentially dilutive securities that have been issued.
Fully diluted shares outstanding can not decrease unless shares are repurchased.
Basic shares outstanding are always equal to or less than fully diluted shares outstanding
2- An analyst has built a forecast showing a rapidly rising Fixed Asset Turnover Ratio. What error has the analyst likely made?
The CAPEX forecast is too low.
The depreciation forecast is too low.
The net profit forecast is too low.
The net sales forecast is too low
3- The number of shares repurchased and/or issued in a given period is shown on the:
income statement.
balance sheet.
cash flow statement.
statement of shareholders equity
4- Assume a firm has a current ratio of 2.0x and a debt ratio of 0.5x. The firm takes a charge to write-down some obsolete inventory. The firm's current ratio and debt ratio will:
Both decrease.
The current ratio will increase and the debt ratio will decrease.
The current ratio will decrease and the debt ratio will increase.
Both increase.
In: Accounting
in R
To explore the characteristics of a Type I error rate, write the R code to do the following:
(a) Generate 30 values from X~N(μX =10,σX=4) and 30 values from Y~N(μY =10,σY=4). Do not print any of these values. Use a t-test to test the hypotheses given above. (You are allowed to use the built-in R function to perform the t-test.)
(b) Include a comment in your code that identifies the p-value and clearly state the conclusion of the test in part (a). The conclusion is either “Reject H0” or “Do not reject H0”.
(c) Repeat part (a) 4000 times, and retain the p-value for each
of the 4000 tests. Each repetition should generate a new sample for
x and a new sample for y.
Do not print the x values or the y values or the p-values
for any of these tests.
Do not use a loop to perform the repetitions.
(d) Calculate the proportion of the 4000 repetitions in which H0 is rejected. Include a comment in our code that provides the proportion.
(e) Generate a histogram of the 4000 p-values.
(f) Include a comment in your code to answer the question: What probability distribution do the p- values appear to follow?
In: Statistics and Probability
a. What is the difference between coupon rate and yield to maturity? How do you use the coupon rate to calculate the periodic payment received from a bond?
b. What is the price of a bond that is currently trading at a yield of 10% and has a face value of $1,000? This bond still has exactly 5 years to maturity. This bond pays semi-annual coupon at an annual rate of 8% (i.e., each coupon is 4%). Show how you found the value. Solving this in a calculator or at some other website that allows you to solve this kind of questions and just putting the value is not going to be an acceptable answer.
c. What is meant by duration of a bond? Describe the steps followed in finding the duration of a bond in Excel when built-in Excel functions are not used.
d. Calculate modi?ed Duration of a bond that pays annual coupon at a rate of 6% and matures in 2 years. This bond has face value of 1,000 and is currently selling at a yield of 8%. Show calculations. Using just modified duration, if yield changes by 0.5%, what is the expected change in the price of the bond? Show calculations. Solving this in a calculator or at some other website that allows you to solve this kind of questions and just putting the value is not going to be an acceptable answer.
In: Finance
Inkjet printers can be described as either continuous or drop-on-demand. In a continuous inkjet printer, letters are built up by squirting drops of ink at the paper from a rapidly moving nozzle. You are part of an engineering group working on the design of such a printer. Each ink drop will have a mass of
1.2×10−8 g . The drops will leave the nozzle and travel toward the paper at 50 m/s, passing through a charging unit that gives each drop a positive charge q by removing some electrons from it. The drops will then pass between parallel deflecting plates, 2 cm long, where there is a uniform vertical electric field with magnitude 8.0×104 N/C . Your team is working on the design of the charging unit that places the charge on the drops.
A) If a drop is to be deflected 0.35 mm by the time it reaches the end of the deflection plates, what magnitude of charge must be given to the drop?
B) How many electrons must be removed from the drop to give it this charge?
C)If the unit that produces the stream of drops is redesigned so that it produces drops with a speed of 25 m/s, what q value is needed to achieve the same 0.35-mm deflection?
In: Physics
Case study: the right portfolio
After working as a securities broker for 20 years, Simon Eckstein decided to lead a less hectic life. He set up an investment consulting firm 2 years ago and has rapidly built his reputation as the best consultant on securities investment in the area. Today, 5 clients called on Simon for his advice on their investment plans. The first is a 35-year-old divorced woman who has 2 teenage sons and wants to invest $50,000. the second and the third are a couple, both having retired and planning to invest $60,000. The fourth is an university freshman, a 19-year-old boy. He lost his parents in a car accident last year and received $2,000,000 from the insurance company. He plans to use some of the compensation to pull himself through the university and the rest to invest. The last is a single woman, 27 years old, working as an accountant for a local department store with an annual salary of 26,000. Her planned investment is $40,000.
(1) What do you think should be appropriate investment goals for the five clients If you were Simon?
(2) What kind of portfolio investment would you suggest for each of them?
In: Finance
To explore the physics of freefall, a curious student climbs to the top of the Las Vegas-version of the Leaning Tower of Pisa (to be built in the style of the Las Vegas-version of the Eiffel Tower, the Statue of Liberty, …) with two identical cannonballs and conducts a series of experiments. Part A) The student drops one cannonball, and exactly 1.0 s later drops the other cannonball from the same height. What is the time interval between the first cannonball striking the ground and the second cannonball striking the ground? Part B) The student drops one cannonball, and after it has fallen exactly 1.0 m drops the other cannonball from the same initial height. What is the distance between the cannonballs when the first cannonball strikes the ground? Part C) The student throws one cannonball directly upward at 5.0 m/s and simultaneously throws the other cannonball directly downward at 5.0 m/s. (This requires great dexterity, but the student has been practicing this maneuver for several months.) What is the difference in speed between the cannonballs when each ball strikes the ground?
Answer Choices: Less than 1.0 m 1.0 m Greater than 1.0 m Cannot be determined
In: Physics