1.A data analytics company wants Short Stop to provide a new
client billing process which integrates their current customers
with new payment options as well as technical information. The
payment for Short Stop’s services would be structured with the
specific payments to be $400,000 immediately, a further $300,000 at
the end of the 2nd year, $500,000 at the end of the 4th year and
$1,000,000 on completion, at the end of the 7th year.
The paid monies can be invested at a nominal rate of 9% p.a.
compounded monthly.
To complete the desired work, Short Stop would have to purchase
additional computers and data sources immediately which are valued
at $1,500,000.
In determining if this project is a viable project for Short Stop,
your manager wants you to provide a detailed information on the
differences between the effective rate of return and a nominal
rate. In what circumstances can we use these to evaluate different
investment opportunities?
2. As information becomes increasingly available, additional
storage is needed for the handling of client’s insurance
capacities. Short Stop is looking to modernise the hardware in
which they store the data. Under the proposed idea, Short Stop
would purchase dedicated virtual servers and cloud storage which
costs $50,000 per year, indefinitely, from the end of year 2 onward
(as it takes a year to implement this change). If implemented, this
would result in an immediate cost saving of $500,000. Short Stop
has estimated that it could invest this money elsewhere, as an
alternative, at 8% p.a.
From a business perspective, describe the concept of time value of
money in such a way that your description sheds light on how
businesses come to financial investment decisions or how
investments today can be valued in the future. In the discussion,
your manager wants a clear description on the benefits of this
concept for the business (or any business).
3. The company has an opportunity to purchase a small company (Trek
Travel) which will augment the current operations of the company.
The cash flows from the company are variable as it is still a
growing company. The owners of the company have indicated that they
would be willing to sell the company to Short Stop for $2 million
dollars. An independent accountant has reviewed Trek Travel’s
annual statements and has estimated the future (yearly) cash flows
from its operations to be:
Yr 1: -$100,000, Yr 2: $300,000, Yr 3: $500,000, Yr 4: $600,000, Yr
5: $800,000 and Yr 6: $1,100,000.
Short Stop requires a rate of return of 9% p.a. for an investment
of this kind.
As this project is the purchase of another company, your manager
wishes for you to explain the objective of maximising / enhancing
shareholder wealth. How would the managers of a company achieve
this goal?
4. The last project involves rolling out a personal finance
advisory platform and includes the servicing and maintenance of the
platform. There are two competing clients who would purchase the
platform, however due to legal, licensing and competition
restrictions, Short Stop can only sell the platform to one of the
clients.
The first client is offering a payment structure comprising of
quarterly payments of $200,000 over a 6-year period, starting at
the end of the 1st quarter.
The second client is offering a different payment structure
compromising monthly payments of $60,000 over the 6-year period.
Additionally, they will pay $30,000 at the start of each year for 6
years, starting immediately.
Short Stop estimates that the personal finance advisory platform
can be created from current embedded systems and augmented with
other applications. The required computing hardware can be
delivered and installed immediately after the client has been
approved, at a cost of $3 million to Short Stop. As such, the
rollout of the project can be completed immediately after the
choice of client.
Given a required rate of return on a project such as this is a
nominal 12% p.a., your manager wishes you to advise on which client
Short Stop should choose to maximise value.
Given that the clients offering to pay for the personal finance
advisory platform are providing payment plans that are regular,
detail using diagrams if needed, how payments received at the
beginning of a period differ from payments received at the end of a
period. Provide some discussion on the present value and future
value of these types of cash flows in terms of how they are
calculated
In: Finance
Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently run out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high.
Sales are made on a cash basis only. Koehl's purchases must be paid for during the following month. Koehl pays herself a salary of $4,400 per month, and the rent is $2,800 per month. In addition, she must make a tax payment of $13,000 in December. The current cash on hand (on December 1) is $850, but Koehl has agreed to maintain an average bank balance of $4,500 - this is her target cash balance. (Disregard the amount in the cash register, which is insignificant because Koehl keeps only a small amount on hand in order to lessen the chances of robbery.)
The estimated sales and purchases for December, January, and February are shown below. Purchases during November amounted to $130,000.
| Sales | Purchases | |||
| December | $160,000 | $25,000 | ||
| January | 42,000 | 25,000 | ||
| February | 58,000 | 25,000 | ||
| I. Collections and Purchases: | ||||||
|
|
|
||||
| Sales | $ | $ | $ | |||
| Purchases | $ | $ | $ | |||
| Payments for purchases | $ | $ | $ | |||
| Salaries | $ | $ | $ | |||
| Rent | $ | $ | $ | |||
| Taxes | $ | --- | --- | |||
| Total payments | $ | $ | $ | |||
| Cash at start of forecast | $ | --- | --- | |||
| Net cash flow | $ | $ | $ | |||
| Cumulative NCF | $ | $ | $ | |||
| Target cash balance | $ | $ | $ | |||
| Surplus cash or loans needed | $ | $ | $ | |||
In: Finance
Problem Set 1 You are the owner of a large data-services firm and are deciding on the purchase of a new hardware cooling system that you expect will yield $233,300 in cost-savings per year for the next 15 years. The installation of this cooling system will cost $3,000,000.
1. At face value, does this system seem profitable? By how much?
2. Assume that your company uses a discount rate of 6%.
a. What is the Net Present Value (NPV) of this project?
b. How does the NPV of this project change as you assume a higher or lower discount rate? Why?
c. What is the IRR/ROI of this project?
d. How much should the yearly cost-savings be in order to break even? i. (hint) use goal-seek/what-if analysis
3. Suppose that you decide to finance the purchase of this system through a loan from the bank. The bank is willing to loan this money over an 8 year term at an interest rate of 4% per year.
a. Using a 70/30 debt-to-equity ratio, what is the NPV of this project? i. (hint) calculate the yearly payment using excel function “PMT”
b. How does the NPV of this project change if a larger portion is financed through equity (e.g. debt-to-equity ratio of 60/40)? Why?
In: Finance
Finance is exciting! In this course, we learned how money can
grow through the use of compounding and interest rates and your
growth strategies may now be different. What are your new financial
goals? Would you like to become more liquid, to save more for your
retirement, or to start a new business? Whatever your goals,
finance is right at the core. Think about what you learned in this
course regarding investing to complete this assignment.
Write a two to three (2-3) page paper in which you:
In: Finance
the stock price is currently $80. The stock price annual up-move factor is 1.15. The risk free rate is 3.9%. Compute the value of a 2 year European call option with an exercise price of $62 using a two-step binomial model
In: Finance
Jeremy earned $100,000 in salary and $6,000 in interest income during the year. Jeremy’s employer withheld $11,000 of federal income taxes from Jeremy’s paychecks during the year. Jeremy has one qualifying dependent child who lives with him. Jeremy qualifies to file as head of household and has $23,000 in itemized deductions.
Determine Jeremy’s tax refund or taxes due.
In: Finance
The Price is Right! Utilizing 1 of these public companies—Target, Coke, Pepsi, Wal-Mart, or J. P. Morgan—determine the right price for that company’s stock in the following 5 easy steps: Visit this Web site. Type in your selected company’s name in the Quote Search box, and select your company's stock symbol. Jot down the current stock price. Select the Analysis tab, and find the Analyst Recommendation box. Jot down the stock’s Earnings Per Share (EPS) Estimate. Select the Price Ratios tab, and jot down the current Price to Earnings Ratio (P/E) for the industry (not the company). Using the PE valuation model to determine the right price for this stock, multiply the industry average P/E ratio by the stock’s EPS to estimate the intrinsic price of the stock. Answer the following questions: Is this stock overvalued or undervalued when compared to the current stock price? What are the analysts’ recommendations for this stock (buy, sell, or hold)? Do you agree with them? Would you consider purchasing this stock? Why?
In: Finance
Q4. When a Mexican distillery offers rebates to its current customers, what growth strategy is the company using? (0.5 points) (20-70 words)
In: Finance
Hand-to-Mouth (H2M) is currently cash-constrained, and must make a decision about whether to delay paying one of its suppliers, or take out a loan. They owe the supplier $ 12 comma 500 with terms of 2.4/10 Net 40, so the supplier will give them a 2.4 % discount if they pay by today (when the discount period expires). Alternatively, they can pay the full $ 12,500 in one month when the invoice is due. H2M is considering three options:
Alternative A: Forgo the discount on its trade credit agreement, wait and pay the full $ 12,500 in one month.
Alternative B: Borrow the money needed to pay its supplier today from Bank A, which has offered a one-month loan at an APR of 12.4 %. The bank will require a (no-interest) compensating balance of 4.6 % of the face value of the loan and will charge a $ 90 loan origination fee. Because H2M has no cash, it will need to borrow the funds to cover these additional amounts as well.
Alternative C: Borrow the money needed to pay its supplier today from Bank B, which has offered a one-month loan at an APR of 14.9 %. The loan has a 1.3 % loan origination fee, which again H2M will need to borrow to cover.
In: Finance
To provide a consistent frame of reference for the company’s financial statements and ratios, assume that the following balance sheet and income statement reflect the company’s pre-transaction condition and performance.
Phoenix Golf Club Co.’s Pre transaction Statement of Financial Condition
| Cash | $15,000 | Accounts payable | $20,000 |
| Marketable securities | 10,000 | Wages payable | 20,000 |
| Accounts receivable | 470,000 | Taxes payable | 10,000 |
| Inventory | 500,000 | Notes payable | 50,000 |
| Prepaid expenses | 5,000 | Total current liabilities | 100,000 |
| Total current assets | 1,000,000 | Long-term debt | 500,000 |
| Total liabilities | 600,000 | ||
| Gross plant and equipment | 1,500,000 | Common stock | 150,000 |
| Accumulated depreciation | 500,000 | Capital paid in excess of par | 350,000 |
| Net plant and equipment | 1,000,000 | Retained earnings | 900,000 |
| Total equity | 1,400,000 | ||
| Total assets | $2,000,000 | Total debt and equity | $2,000,000 |
|
Phoenix Golf Club Co.’s Pre transaction Statement of Financial Performance |
|
|---|---|
| Sales | $5,000,000 |
| Less: Cost of goods sold¹ | 2,000,000 |
| Gross profit | 3,000,000 |
| Less: Operating expenses | 600,000 |
| Operating profit (EBIT) | 2,400,000 |
| Less: Interest expense² | 33,000 |
| Earnings before taxes (EBT) | 2,367,000 |
| Less: Tax expense³ | 828,450 |
| Net income | $1,538,550 |
¹Cost of goods sold equals 40% of sales.
²Interest expense equals 6% of the combined notes payable and long-term debt balances.
³The average federal and state tax rate is 35%.
Indicate if any of the listed financial statement accounts is affected by the following business transactions and whether the listed ratios will increase, decrease, or remain unchanged as a result of the transaction. (Hint: Assume that the business transaction occurs exactly as stated without interpreting it further. Do not consider any related transactions that may occur before or after the specified transaction. Assume there are 365 days in a year.)
Business Transaction 1
Phoenix Golf Club Co. (PGC) sells 25,000 shares of new common stock ($1 per share par value) to new and existing shareholders for $20 per share.
|
Financial Account |
Check if the Account Is Affected by the Specified Transaction |
|
|---|---|---|
| Cash | ||
| Operating income | ||
| Long-term debt | ||
| Common stock | ||
| Capital paid-in excess of par |
|
Financial Ratio |
Ratio’s Behavior |
|---|---|
| Inventory turnover | |
| Debt ratio | |
| Times interest earned | |
| Operating profit margin | |
| Basic earnings power | |
| Current ratio |
Business Transaction 2
Phoenix Golf Club Co. (PGC) switches from holding an available inventory to a just-in-time inventory system, thereby reducing its inventory by 80.00%.
|
Financial Account |
Check if the Account Is Affected by the Specified Transaction |
|
|---|---|---|
| Inventory | ||
| Accounts payable | ||
| Prepaid expenses | ||
| Total assets | ||
| Common stock |
|
Financial Ratio |
Ratio’s Behavior |
|---|---|
| Average collection period | |
| Inventory turnover | |
| Fixed assets turnover | |
| Quick ratio | |
| Return on assets | |
| Debt ratio |
In: Finance
Venture capital financing is a type of funding which assembles cash from investors and lends it to startup businesses that have high potential for success. Venture capital investments usually encompass very high risk; however, the reward has the potential to exceed the risk. The process for acquiring venture capital financing sometimes is complicated, but generally there are five stages in the process of procuring venture capital financing.
In: Finance
n this unit we learned to conduct a retirement needs analysis taking into account various assumptions such as inflation rate, retirement period, life expectancy, income sources, and other variables, and determine financial needs during the accumulation and retirement period. Lets extend the discussion by examining the practical implications of these concepts. TIAA-CREF has an excellent site that provides a consider- able amount of information on retirement planning and retirement options. Visit the site at tiaa-cref.org click on the What We Offer tab, and examine the information in the Retirement section.
In: Finance
Why do firms have trouble managing their cash flow? What events cause a cash flow crisis?
In: Finance
Budgeting
Describe your company's annual budget process.
In: Finance
Indicate and Discuss how will be affected the prices (and the yields) of the next Bonds (no calculations required) i. US Treasury Bonds with Moderate GDP Growth ii. German Government Bonds with Higher than expected GDP Growth iii. Investment Grade Corporate Bonds with Terrorist attack in London, NY. iv. Spanish, Italian and Portuguese Bonds with EU Debt Crisis v. High Yield Corporate Bonds with US Debt out of control due to Trump cutting Taxes.
In: Finance