|
A manufacturer is planning to produce and sell a new product. It would cost $20 million at Year 0 to buy the equipment necessary to manufacture the product. The project would require net working capital at the beginning of each year in an amount equal to 15% of the year's projected sales; for example, NWC0 = 15%(Sales1). The product would sell for $30 per unit, and believes that variable costs would amount to $15 per unit. After Year 1, the sales price and variable costs will increase at the inflation rate of 3%. The project's fixed costs would be $500,000/year in Year 1 and would increase with inflation. |
|
|
The products will be sold for 4 years. If the project is undertaken, it must be continued for the entire 4 years. The firm believes it could sell 500,000 units per year. |
|
|
The equipment would be depreciated over using straight-line depreciation. The estimated market value of the equipment at the end of the project’s 4-year life is $500,000. The federal-plus-state tax rate is 40%. Its cost of capital is 10%. Do parts a-e in Excel with separate tabs for each part. Do part f) in Word. |
|
|
Develop a spreadsheet model, and use it to find the project’s NPV, IRR, and payback. (Suggestion: Use the ch. 13 Build A Model as a reference. However, your spreadsheet model should be clearly built from scratch, not copied and pasted in that one. The capital budgeting metrics are covered in chapter 12 ). Now conduct a sensitivity analysis to determine the sensitivity of NPV to changes in the sales price, variable costs per unit, and number of units sold. Set these variables’ values at least 5%, 10%, and 20% above and below their base-case values. Include a graph in your analysis. To which variable does NPV appear most sensitive? (Suggestions: Use Excel’s Data Table feature, or re-calculate the NPV of each input level and then copy and paste the results). Now conduct a scenario analysis. Assume that there is a 25% probability that best-case conditions, with each of the variables discussed in Part b being 20% better than its base-case value, will occur. There is a 25% probability of worst-case conditions, with the variables 20% worse than base, and a 50% probability of base-case conditions. (Suppose the average CV of this company's projects is 2.0. Is this project more or less risky than the average project for this company?). Use the approach in the Build-A-Model. Set up your own numerical example of a real option. You can choose either a timing or an abandonment option. Use any probabilities and cash flows that make sense. Extra credit: Set up your own Monte Carlo simulation. (See discussion in ch. 13 and the Excel ToolKit)
Write an approximately 2 page report suitable for a CFO with your recommendation about whether to approve or reject this project. The recommendation should have separate sections including summary results from the spreadsheet model, interpretations of the capital budgeting metrics, interpretations of your sensitivity and scenario analysis, the analysis of your real option, and the Monte Carlo simulation, if applicable. Include any other factors in your recommendation that you believe are relevant. |
In: Finance
Conduct a financial analysis of water system operation for the City of Smallville over the next ten years. Use the data below. If you lack data, make assumptions or ask for it. Analyze O&M, capital costs and cash flows. The water system currently serves 100,000 people and is to be expanded to handle a population influx of 5% per year for the next ten years. Land use is mixed residential and commercial, but no industry. Base your estimates on residential demands and assume that commercial water use adds 15% to the residential use. You expand the system to accommodate growth and simultaneously maintain and renew the existing system during the period. The system is currently 15 years old and has depreciated on a 30-year depreciation cycle at 3.33% per year on a straight-line basis.
Your system expansion will be staged so that half is built now and half in five years. When you also invest in system renewal to overcome depreciation, the investments would be added to the costs of system expansion. System renewal is governed by the rule that current system value must not fall below 50% of replacement value.
You will take a loan for the first part of the construction and issue bonds for the next increment (in five years). You may vary from this if you choose different capital financing vehicles. Loans are “revolving loans” and come from an infrastructure bank. Annual loan payments begin in one year and continue for ten years. Recommend how to finance the expansion and renewal with funding from plant investment fees, water use fees, sales tax revenues, and property tax revenues. Commercial property has 25% of the assessed valuation of the residential property.
|
Current population |
100,000 (33,333 households) |
|
Rate of population growth |
5% per year for ten years; 0% after that. |
|
Per capita water usage (average) |
150 gpcd |
|
Land Use |
Mixed residential and commercial. |
|
Planning horizon for capital improvements |
10 years to meet demands; 30 yrs for system life |
|
Plant investment fee |
$5,000 per house connection |
|
Current water fees |
$2.50/1000 gal |
|
Property tax dedicated to water system improvements |
0.8 mills |
|
Assessed valuation residential (market value * 0.2) |
$980 million |
|
Sales tax dedicated to water system |
0.8% |
|
Current anticipated taxable sales |
$800 million per year |
|
Interest rate on loan (due in ten years) |
8% |
|
Interest rate on bonds (use 20 year life) |
6% |
|
Projected inflation rate |
0% |
|
Capital cost of new or replacement system |
$3,000 for each new person |
|
Current value of existing system (average age15 years) |
Replacement value less 15 years depreciation |
|
Capital improvement goal |
System value not below 50% of replacement |
|
Depreciation of assets |
3.33% per year |
|
O&M cost |
$50 per capita per year |
1. Set up a spreadsheet and forecast cash flows for the next fifteen years.
2. Schedule for capital improvements (the capital improvement program)
In: Accounting
Reusable Passwords The most common authentication credential is the reusable password, which is a string of characters that a user types to gain access to the resources associated with a certain username (account) on a computer. These are called reusable passwords because the user types the password each time he or she needs access to the resource. Unfortunately, the reusable password is the weakest form of authentication, and it is appropriate only for the least sensitive assets.Ease of Use and Low Cost: The popularity of password authentication is hardly surprising. For users, passwords are familiar and relatively easy to use. For corporate IT departments, passwords add no cost because operating systems and many applications have built-in password authentication.Dictionary Attacks The main problem with passwords is that most users pick very weak passwords. To break into a host by guessing and trying passwords, hackers often use password dictionaries. These are lists of passwords likely to succeed. Running through a password dictionary to see if a password is accepted for a username is called a dictionary attack. Password dictionaries typically have three types of entries: a list of common password, the words in standard dictionaries, and hybrid versions of words such as capitalizing the first letter and adding a digit at the end. If a password is in one of these dictionaries, the attacker may have to try a fewthousand passwords, but this will only take seconds. No password that is in a cracker dictionary is adequately strong, no matter how long it is. Fortunately, good passwords cannot be broken by dictionary attacks. Good passwords have two characteristics. First, they are complex. It is essential to have a mix of upper and lower case letters that does not have a regular pattern such as alternating uppercase letters lowercase letters. It is also good—and some would say necessary—to include non-letter keyboard characters such as the digits (0 through 9) and other special characters (&, #./,?, etc.). If a password is complex, it can only be cracked by a brute-force attack, in which the cracker first tries all combinations of one character passwords, all combinations of two-character passwords, andso forth, until the attacker finds one that works. Complexity is not enough, however. Complex passwords must also be long. For short complex passwords, brute force attacks will still succeed. Beyond about 10 or 12 characters, however, there are too many combinations to try in a reasonable period of time.Overall, while long complex passwords can defeat determined attacks, most users select passwords that can be cracked with dictionary attacks. Reusable passwords are no longer appropriate in an era when password cracking programs can reveal most passwords in seconds or minutes. Passwords are only useful for non-sensitive assets.
1.Discuss and explain the types of passwords are susceptible to dictionary attacks?[5marks]
2.Can a password that can be broken by a dictionary attack be adequately strong if it is very long?Justify your answer. [5marks]
3.Explain the types of passwords can be broken only by brute-force attacks.[5marks]
4.What are the characteristics of passwords that are safe from even brute-force attacks?[5marks]
5.Discuss why is it undesirable to use reusable passwords for anything but the least sensitive assets
In: Computer Science
Mary Milken is the CFO of the Rbeck Company in Miami, Florida. The company is a closely held custom yacht builder with about 200 technical workers (engineers, marine architects, mechanics, boat workers, and so on), and 12 employees in its main office staff. Her primary job is to prepare the financial statements with the assistance of two full-time accountants. She normally follows generally accepted accounting principles, but she sometimes ignores them when she thinks they do not lead to what she considers best practices for the small number of her company’s shareholders.
In the previous decade, the company was owned by three sisters, each of whom served on the board of directors. One of the three, Vanessa Rbeck, served as the CEO during that period. The other two have always deferred to her with respect to her operational management decisions.
Only a month ago, however, Vanessa’s sisters were killed when their private plane crashed enroute to the Bahamas, which they frequently visited on weekends for relaxation. Upon their death, all of their shares in the Rbeck company transferred to a single trustee in one of the large South Florida banks. Each sister had held her shares in revo- cable living trusts with the same bank named as successor trustee.
As soon as the funerals were over, Mary and Vanessa met with the trustee, Annie Crusher. The meeting did not go well. Annie had grown up working in a family-owned retail boat business, and she thought her knowledge of the industry transferred to the yacht-building business. She began asking Vanessa a rapid succession of unfriendly questions in an adversarial tone of voice. Her questions strongly implied that a yacht- building business did not belong in South Florida but offshore where labor is cheaper. After the meeting, both Mary and Vanessa became afraid that Annie would do some- thing crazy like fire them both or liquidate the business.
For the previous five years, Rbeck’s stock had sold for a steady $12 per share, with $8 per share in dividends. Vanessa received a good salary, but she depended on the dividends to send her children to private schools and to pay the large mortgage on her waterfront home in South Beach. She immediately realized that she was now at Annie’s mercy; she could easily cut off Vanessa’s dividends, lower her salary, or put her out of work.
To make things worse, Mary was almost finished with the most recent annual report, and it appeared that earnings were down for the first time ever. Her preliminary calculations showed earnings per share somewhere near $8.
The problem with earnings had been caused by large bad debts from three clients who had been arrested for drug trafficking. Rbeck had entirely financed luxury yachts for the three clients because of their excellent credit history and prominence in the business community. However, the federal government seized all of the clients’ assets, leaving nothing for Rbeck but the three half-built yachts.
After thinking things over, Vanessa asked Mary to find a way to avoid having to report lower earnings because of her concern as to how Annie might respond to the decline in earnings. Mary considered various options:
• Increase the estimated percentage of completion on all yachts in work-in-process inventory by 15 percent. This would wipe out most of the loss. Work in process estimates have always been very conservative anyway.
• Recognize revenue on the three yachts in default. It would be very difficult to sell them at a good price, but she could always argue that they could be sold if she could keep a straight face. The best strategy would be to find new buyers for them, but that could take a couple of years.
• Switch to mark-to-market accounting for some of the yachts in progress so the company could recognize all of the profit when contracts with other clients are signed.
a. Is any option that Mary is considering acceptable under generally accepted accounting principles? Why or why not?
b. DoanyoftheoptionsbeingconsideredbyMaryconstitutefinancialstatementsfraud?
c. How would you handle the entire situation if you were in Mary’s shoes?
In: Accounting
FIFO method (continuation of 17-35). Do Problem 17-35 using the FIFO method of process costing. If you did Problem 17-35, explain any difference between the cost of work completed and transferred out and the cost of ending work in process in the Assembly Department under the weighted-average method and the FIF0 method.
In: Statistics and Probability
Retail Inventory Method
Uncle Butch's Hunting Supply Shop reports the following information related to inventory:
Beginning inventory Cost- $ 35,000 Retail- $ 92,000
Purchases Cost- 75,000 Reatil- 200,000
Net additional markups Cost- 0 Retail- 15,000
Net markdowns Cost- 0 Retail- (22,000)
Goods available for sale Cost- $110,000 Retail- $ 285,000
Sales (178,000)
Ending inventory at retail $ 107,000
Calculate Uncle Butch's' ending inventory using the retail inventory method under the FIFO cost flow assumption. Round the cost-to-retail ratio to 3 decimal places.
In: Accounting
1. Demand: P=120-Q Total Cost: TC=Q2
Marginal Revenue: MR=120-2Q Marginal Cost: MC=2Q
What is the amount of profit for this monopolist?
2. Demand: P=120-Q Total Cost: TC=Q2
Marginal Revenue: MR=120-2Q Marginal Cost: MC=2Q
For this monopolist, the profit-maximizing price is ________ and the profit-maximizing quantity is _________.
3. Demand: P=120-Q Total Cost: TC=Q2
Marginal Revenue: MR=120-2Q Marginal Cost: MC=2Q
Compared to perfect competition where P=MC, what is the amount of deadweight loss caused by this monopolist _________.
In: Economics
Q1 (Investor, capital gains)
Karl Kruger is a 38 year-old single Australian resident taxpayer. During the 2017/18 tax year, Karl received and retained the following records:
|
Account Summary received from XYZ Bank |
|
|
Interest from Term Deposits |
$ 17,200 |
|
Interest from Savings Account |
350 |
|
Bank Charges relating to Term Deposits |
40 |
|
Interest charged on line of credit (used for personal expenses) |
715 |
|
4 February 2018 Dividend Statement from Eccy Ltd |
|
|
Franked Dividend |
2,100 |
|
Franking Credits |
900 |
|
Rental Summary from Hawkeye Real Estate |
|
|
Gross Rent Received |
15,200 |
|
Rental expenses: |
|
|
Agent’s Commission |
920 |
|
Council Rates |
1,490 |
|
Landlord Insurance |
290 |
Other Information:
|
ASSET |
PURCHASE COST |
ACQUISITION DATE |
DISPOSAL DATE |
SALE PRICE |
|
Quality shares |
$12,000 |
12 Apr 12 |
10 May 18 |
$18,600 |
|
Oil Painting (collectable) |
6,000 |
03 Mar 98 |
26 Feb 18 |
5,200 |
|
Crummy shares |
4,000 |
21 Aug 08 |
03 May 18 |
2,500 |
required :Prepare a statement calculating Karl’s tax payable/refundable.
(Tax losses, partner in partnership)
The following data relates to Stephanie Garner, a resident taxpayer. Stephanie derives income from a public relations business and is also a partner in a marketing business.
|
2015/16 |
2016/17 |
2017/18 |
|
|
Assessable business income |
$ 93,400 |
$ 126,000 |
$ 133,400 |
|
General business deductions |
80,000 |
129,000 |
119,200 |
|
Share of Partnership Net Income (Loss) |
(21,800) |
14,900 |
(5,600) |
|
Superannuation and Gifts |
4,000 |
11,000 |
8,000 |
|
Net exempt income |
1,500 |
3,000 |
2,000 |
General business deductions are separate from personal superannuation, gifts, partnership losses and losses of previous years.
Please assume that the necessary tests have been satisfied such that any partnership losses from Stephanie's share in the marketing business may be deducted from other income as appropriate.
Required: For 2016/2017 and 2017/2018 , determine Stephanie’s Taxable Income and any losses that may be carried forward
In: Accounting
Q1 (Investor, capital gains)
Karl Kruger is a 38 year-old single Australian resident taxpayer. During the 2017/18 tax year, Karl received and retained the following records:
|
Account Summary received from XYZ Bank |
|
|
Interest from Term Deposits |
$ 17,200 |
|
Interest from Savings Account |
350 |
|
Bank Charges relating to Term Deposits |
40 |
|
Interest charged on line of credit (used for personal expenses) |
715 |
|
4 February 2018 Dividend Statement from Eccy Ltd |
|
|
Franked Dividend |
2,100 |
|
Franking Credits |
900 |
|
Rental Summary from Hawkeye Real Estate |
|
|
Gross Rent Received |
15,200 |
|
Rental expenses: |
|
|
Agent’s Commission |
920 |
|
Council Rates |
1,490 |
|
Landlord Insurance |
290 |
Other Information:
|
ASSET |
PURCHASE COST |
ACQUISITION DATE |
DISPOSAL DATE |
SALE PRICE |
|
Quality shares |
$12,000 |
12 Apr 12 |
10 May 18 |
$18,600 |
|
Oil Painting (collectable) |
6,000 |
03 Mar 98 |
26 Feb 18 |
5,200 |
|
Crummy shares |
4,000 |
21 Aug 08 |
03 May 18 |
2,500 |
required :Prepare a statement calculating Karl’s tax payable/refundable.
(Tax losses, partner in partnership)
The following data relates to Stephanie Garner, a resident taxpayer. Stephanie derives income from a public relations business and is also a partner in a marketing business.
|
2015/16 |
2016/17 |
2017/18 |
|
|
Assessable business income |
$ 93,400 |
$ 126,000 |
$ 133,400 |
|
General business deductions |
80,000 |
129,000 |
119,200 |
|
Share of Partnership Net Income (Loss) |
(21,800) |
14,900 |
(5,600) |
|
Superannuation and Gifts |
4,000 |
11,000 |
8,000 |
|
Net exempt income |
1,500 |
3,000 |
2,000 |
General business deductions are separate from personal superannuation, gifts, partnership losses and losses of previous years.
Please assume that the necessary tests have been satisfied such that any partnership losses from Stephanie's share in the marketing business may be deducted from other income as appropriate.
Required: For 2016/2017 and 2017/2018 , determine Stephanie’s Taxable Income and any losses that may be carried forward
In: Accounting
Jazz Mobile phone is a famous multinational brand
producing smart phones. The main aim for
Jazz is to satisfy its users with user friendly, innovative and
elegant devices that simplify the
problems of the customers and enable them to enjoy the product.
Jazz mobile have different series
with amazing features of large display size, amazing battery time,
high definition camera quality
and large internal storages. Jazz have a comprehensive portfolio of
hardware, software and services
that enable the digital transformation of networks to address
capacity needs, reduce complexity
and leverage network intelligence to create and deliver new
services. Operational excellence
remains a source of competitive advantage for Jazz and this becomes
the foundation of their
strategy.
According to their vision, Jazz Research is actively conducting
research and development (R&D) to
identify new future growth areas and secure advanced technologies
for its products to create new value
and improve people’s lives. Jazz has a global network of R&D
centers, each with individual
technology and competence specialties. Jazz research promises to
continue working hard to become
a global top research institute that creates new values for the
future through ceaseless innovation and
intelligence.
Recently Jazz has launched a new phone Book 8. It has the biggest
screen and battery, the fastest
processor and the largest storage. It’s a phone designed and built
for the power user who won’t
settle for anything less. The Book 8 gives the most advanced
features than any other series. After
few days of launching the phone, the customers had a complaint that
there is some problem with
the phone. Jazz management ordered the inquiry and identify the
issues arising out of the battery
design and manufacturing process. Jazz had to recall about 1.5
million phones after complaints of
manufacturing issues.
Research and development along with the management is concerned
about the incident and their
goodwill across the world. R &D is now working to find out the
reasons for the failure of their
new Book 8. They wanted to ensure that this problem should not
exist for the new model coming
in the future.
a. Sometimes a minor negligence can cost the company in terms of
their repute, money, time and
effort. Based on company’s previous experience of Book 8, what
steps are required to be followed
by Jazz for comprehensive research for their upcoming model. What
suggestions would you
recommend to Jazz R&D to make their research successful?
b. Write the analysis report for the causes of failure of Book 8.
What were the practices not
followed before launch of Book 8?
In: Accounting