A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an annual fixed rate of 5.49% (15-year term) with monthly payments of $1,881.46. They just made their 50th payment, and the current balance on the loan is $208,555.87.
Interest rates are at an all-time low, and Dave and Jana are thinking of refinancing to a new 15-year fixed loan. Their bank has made the following offer: 15-year term, 3.0%, plus out-of-pocket costs of $2,937. The out-of-pocket costs must be paid in full at the time of refinancing.
Build a spreadsheet model to evaluate this offer. The Excel function:
=PMT(rate, nper, pv, fv, type)
calculates the payment for a loan based on constant payments and a constant interest rate. The arguments of this function are:
rate   = the interest rate for the loan
nper   = the total number of payments
pv   = present value (the amount borrowed)
fv   = future value [the desired cash balance after the last payment (usually 0)]
type   = payment type (0 = end of period, 1 = beginning of the period)
For example, for Dave and Jana’s original loan, there will be 180 payments (12*15 = 180), so we would use =PMT(0.0549/12, 180, 230415,0,0) = $1,881.46. Note that because payments are made monthly, the annual interest rate must be expressed as a monthly rate. Also, for payment calculations, we assume that the payment is made at the end of the month.
The savings from refinancing occur over time, and therefore need to be discounted back to current dollars. The formula for converting K dollars saved t months from now to current dollars is:
where r is the monthly inflation rate. Assume that r = 0.002 and that Dave and Jana make their payment at the end of each month.
Use your model to calculate the savings in current dollars associated with the refinanced loan versus staying with the original loan.
If required, round your answer to the nearest whole dollar amount. If your answer is negative use “minus sign”.

1.

a. You see the current 3-month T-bill quoted on a discount basis at 1.9425-1.9350. The T-bill has a $10,000 face value. The T-bill has 86 days until maturity. What price would you pay for one of these T-bills (disregarding transaction charges)? Enter the price you would pay rounded to the nearest cent.

b. You see the current 3-month T-bill quoted on a discount basis at 1.9325-1.9250. The T-bill has a $10,000 face value. The T-bill has 86 days until maturity. What is the bond equivalent ask yield? Enter the yield rounded to two digits in this format, 4.56%

c. You are an investor in the 34% marginal tax bracket. You are looking to invest some of your funds in a fixed income security. You see a Mecklenburg County municipal bond with a yield of 2.75%. The other bond you are considering is a Ford Motor Company corporate bond yielding 4.00%. On the basis of taxable equivalent yield, which bond would you choose?

d. You open a brokerage account and purchase 500 shares of MMM at $150.39 by borrowing half of the required funds (you pay for 250 shares and borrow enough to buy another 250 shares). You pay 6% annual interest on the borrowed money. At the end of one year, what price would trigger a margin call if the maintenance margin were set at 35% by the brokerage firm? Enter the margin call price by rounding to the nearest cent in this format, $123.45

1.

a. You are creating an index for the four following stocks:

What is the one day return for the index if it is price-weighted? Present your answer as the percent change from t=0 to t=1 to the nearest two decimals in this format, 1.23%

b.

What is the one day return for the index if it is market capitalization-weighted? Present your answer as the percent change from t=0 to t=1 to the nearest two decimals in this format, 1.23%

c.

Suppose that at the conclusion on t=1 trading day, stock ABC does a 2:1 stock split, what is the new divisor for your price-weighted index? Present your answer rounded to the nearest two digits like this, 1.23

Lisa Lasher buys 400 shares of stock on margin at $21 per share. If the margin requirement is 70 percent, how much must the stock rise for her to realize a 40-percent return on her invested funds? (Ignore dividends, commissions, and interest on borrowed funds.) Round your answer to the nearest cent.

The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for 2019. INCOME STATEMENT OF QUICK BURGER CORP., 2019 (Figures in $ millions) Net sales $ 27,571 Costs 17,573 Depreciation 1,406 Earnings before interest and taxes (EBIT) $ 8,592 Interest expense 521 Pretax income 8,071 Federal plus other taxes 2,825 Net income $ 5,246 BALANCE SHEET OF QUICK BURGER CORP., 2019 (Figures in $ millions) Assets 2019 2018 Liabilities and Shareholders' Equity 2019 2018 Current assets Current liabilities Cash and marketable securities $ 2,340 $ 2,340 Debt due for repayment — $ 379 Receivables 1,379 1,339 Accounts payable $ 3,407 3,147 Inventories 126 121 Total current liabilities $ 3,407 $ 3,526 Other current assets 1,093 620 Total current assets $ 4,938 $ 4,420 Fixed assets Long-term debt $ 13,637 $ 12,138 Property, plant, and equipment $ 24,681 $ 22,839 Other long-term liabilities 3,061 2,961 Intangible assets (goodwill) 2,808 2,657 Total liabilities $ 20,105 $ 18,625 Other long-term assets 2,987 3,103 Total shareholders’ equity 15,309 14,394 Total assets $ 35,414 $ 33,019 Total liabilities and shareholders’ equity $ 35,414 $ 33,019 In 2019 Quick Burger had capital expenditures of $3,053.The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for 2019. INCOME STATEMENT OF QUICK BURGER CORP., 2019 (Figures in $ millions) Net sales $ 27,571 Costs 17,573 Depreciation 1,406 Earnings before interest and taxes (EBIT) $ 8,592 Interest expense 521 Pretax income 8,071 Federal plus other taxes 2,825 Net income $ 5,246 BALANCE SHEET OF QUICK BURGER CORP., 2019 (Figures in $ millions) Assets 2019 2018 Liabilities and Shareholders' Equity 2019 2018 Current assets Current liabilities Cash and marketable securities $ 2,340 $ 2,340 Debt due for repayment — $ 379 Receivables 1,379 1,339 Accounts payable $ 3,407 3,147 Inventories 126 121 Total current liabilities $ 3,407 $ 3,526 Other current assets 1,093 620 Total current assets $ 4,938 $ 4,420 Fixed assets Long-term debt $ 13,637 $ 12,138 Property, plant, and equipment $ 24,681 $ 22,839 Other long-term liabilities 3,061 2,961 Intangible assets (goodwill) 2,808 2,657 Total liabilities $ 20,105 $ 18,625 Other long-term assets 2,987 3,103 Total shareholders’ equity 15,309 14,394 Total assets $ 35,414 $ 33,019 Total liabilities and shareholders’ equity $ 35,414 $ 33,019 In 2019 Quick Burger had capital expenditures of $3,053. a. Calculate Quick Burger’s free cash flow in 2019. (Enter your answer in millions.) b. If Quick Burger was financed entirely by equity, how much more tax would the company have paid? (Assume a tax rate of 21%.) (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.) c. What would the company’s free cash flow have been if it was all-equity financed? (Enter your answer in millions.)

You are considering an investment in Fields and Struthers, Inc. and want to evaluate the firm’s free cash flow. From the income statement, you see that Fields and Struthers earned an EBIT of $78 million, had a tax rate of 30 percent, and its depreciation expense was $9 million. Fields and Struthers’ gross fixed assets increased by $44 million from 2017 to 2018. The firm’s current assets increased by $32 million and spontaneous current liabilities increased by $22 million. Calculate Fields and Struthers’ operating cash flow for 2018. Calculate Fields and Struthers’ investment in operating capital for 2018. Calculate Fields and Struthers’ free cash flow for 2018.

For this discussion topic, I'm asking an open-ended question as to whether you feel contract law, and by extension, contracts, are essential to businesses.  

If you agree that contracts are essential to business, explain why you feel that way and provide at least two examples of why you feel contracts are essential.

If you feel contract law, and by extension contracts, are not essential, explain your position and provide at least two examples that support your position.

Assignment Details - This is a 5 part deliverable

PART 1

Your facility has 2000 cases in the following payer mix:

• 40% commercial insurances
• 25% Medicare insurance
• 15% Medicaid insurance
• 15% liability insurance
• 5% all others, including self-pay

What are the proportions of the total cases for each payer?

PART 2

The average Medicare rate for each case is $6,200. Use this as the baseline. Commercial insurances average 110% of Medicare, Medicaid averages 65% of Medicare., Lliability insurers average 200% of Medicare, and the others average 100% of Medicare rates.

1. Calculate the individual reimbursement rates for all 5 payers?
2. What is your expected Accounts Receivable?

PART 3

Which of the following costs are fixed, which are variable, and which are direct or indirect:

• Materials/supplies (gowns, drapes, bedsheets)
• Wages (nurses, technicians)
• Utility, building, usage exp (lights, heat, technology)
• Medications
• Licensing of facility
• Per diem staff
• Insurances (malpractice, business, and so on)

PART 4

Given the following costs per case:

• Materials/supplies: $2,270
• Wages: $2,000
• Utility, building, usage exp: $1,125
• Insurances (malpractice, business, and so on): $175

What is the total cost of all combined cases?

PART 5

Calculate the difference between accounts receivable (A/R) and accounts payable (A/P)

1. Calculate the future value of these deposits. Remember to total your answer. Assume end of year deposits.

Part a:

n          Deposit            Terms                          FVIF               $

1          $1000              5%, semi-annual

2          $1500              6%, monthly

3          $2000              8%, quarterly

4          $1000              12%, annual

5          $2000               8%, semi-annual

sset management ratios

Asset management ratios are used to measure how effectively a firm manages its assets, by relating the amount a firm has invested in a particular type of asset (or group of assets) to the amount of revenues the asset is generating. Examples of asset management ratios include the average collection period (also called the days sales outstanding ratio), the inventory turnover ratio, the fixed asset turnover ratio, and the total asset turnover ratio.

Consider the following case:

Crockett Electronics has a quick ratio of 2.00x, $29,475 in cash, $16,375 in accounts receivable, some inventory, total current assets of $65,500, and total current liabilities of $22,925. The company reported annual sales of $700,000 in the most recent annual report.

Over the past year, how often did Crockett Electronics sell and replace its inventory?

2.86x

39.18x

35.62x

8.01x

The inventory turnover ratio across companies in the electronics industry is 30.277x. Based on this information, which of the following statements is true for Crockett Electronics?

Crockett Electronics is holding less inventory per dollar of sales compared with the industry average.

Crockett Electronics is holding more inventory per dollar of sales compared with the industry average.

You are analyzing two companies that manufacture electronic toys—Like Games Inc. and Our Play Inc. Like Games was launched eight years ago, whereas Our Play is a relatively new company that has been in operation for only the past two years. However, both companies have an equal market share with sales of $700,000 each. You’ve collected company data to compare Like Games and Our Play. Last year, the average sales for all industry competitors was $1,785,000. As an analyst, you want to make comments on the expected performance of these two companies in the coming year. You’ve collected data from the companies’ financial statements. This information is listed as follows: (Note: Assume there are 365 days in a year.)

Data Collected (in dollars)

Using this information, complete the following statements to include in your analysis.

Risk premiums  In January 2016​, ​Anheuser-Busch issued an outstanding bond that pays a 3.2​% coupon​ rate, matures in January 2023​, and has a yield to maturity of 2.72​%. In January 2017​, Santander Holdings issued an outstanding bond that pays a 3.576​% coupon​ rate, matures in January 2023​, and has a yield to maturity of 3.346​%. a. Does the​ Anheuser-Busch bond sell at a​ premium, at​ par, or at a​ discount? How do you​ know? What about the Santander​ bond? b. Which bond would you guess has a higher​ rating? Why? c. Can you draw any conclusion about the shape of the yield​ curve, either now or when these bonds were first​ issued, from the information given in the​ problem? Why or why​ not?

6. Explain the various inputs to the present value of an annuity (i.e. C, r, t, and PVA). How is the value of the annuity impacted by each input?

Explain what happens to the value of a perpetuity over time, assuming the perpetuity has begun.

Explain what happens to the value of a growing perpetuity over time, assuming the growing perpetuity has begun.

Explain why the value today of a perpetuity that doesn’t start until sometime in the future is not simply C/r.

thank you.

You are saving for retirement. Starting this month, you will deposit $600 per month into a stock account that earns 9% interest. In ten years, you will begin depositing an additional $350 per month into a bond account that earns 6% interest. You expect interest rates to shift upwards 1.5% 20 years from now. This means, at that point, each of the accounts listed above will earn interest 1.5% higher than before. How much will you have when you retire if you plan to retire in 37 years?