The Landers Corporation needs to raise $1.70 million of debt on a 20-year issue. If it places the bonds privately, the interest rate will be 14 percent. Fifteen thousand dollars in out-of-pocket costs will be incurred. For a public issue, the interest rate will be 12 percent, and the underwriting spread will be 1 percent. There will be $130,000 in out-of-pocket costs. Assume interest on the debt is paid semiannually, and the debt will be outstanding for the full 20-year period, at which time it will be repaid. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods.

a. For each plan, compare the net amount of funds initially available—inflow—to the present value of future payments of interest and principal to determine net present value. Assume the stated discount rate is 18 percent annually. Use 9.00 percent semiannually throughout the analysis. (Disregard taxes.) (Assume the $1.70 million needed includes the underwriting costs. Input your present value of future payments answers as negative values. Do not round intermediate calculations and round your answers to 2 decimal places.)
  

b. Which plan offers the higher net present value?
  

Marcie is a new client and a 22-year-old female who works as a receptionist in a doctor's office. She has just revealed to you during the intake session that she has recently lost interest in most activities, has been sleeping a great deal yet feels tired all the time, and sometimes wishes she could cease to exist. She mentioned feeling as though she has been "on an emotional roller coaster" during the past year, throughout her on-again/off-again relationship with a 35-year-old married man. The last breakup with him seemed final, and Marcie has felt herself sinking deeper and deeper into depression ever since. When probed further about suicidal ideations, Marcie admitted that she has considered killing herself, although she is uncertain whether or not she would actually do it. She said that she is currently in possession of a gun that her friend allowed her to keep in her home following a rash of burglaries in the neighborhood, but she does not know whether she would actually use it.

You have consulted with your supervisor, who has agreed that Marcie should be referred immediately for a psychiatric evaluation and has instructed you to arrange for Marcie to go directly from your office to a nearby hospital. Marcie told you that her mother accompanied her and is in the waiting room, but she has emphatically stated that she does not want her mother to know what is going on with her. How should this delicate situation be handled? Why? What are three ethical and/or legal concerns about this case?

Assume an investment costing $24,869 will earn $10,000 a year for ten years. If the discount rate is 15%, what is the NPV of this project?

Show this in excel with the formulas for excel shown. the formulas must be shown

The Landers Corporation needs to raise $2.10 million of debt on a 20-year issue. If it places the bonds privately, the interest rate will be 12 percent. Thirty five thousand dollars in out-of-pocket costs will be incurred. For a public issue, the interest rate will be 10 percent, and the underwriting spread will be 5 percent. There will be $90,000 in out-of-pocket costs. Assume interest on the debt is paid semiannually, and the debt will be outstanding for the full 20-year period, at which time it will be repaid. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods.

a. For each plan, compare the net amount of funds initially available—inflow—to the present value of future payments of interest and principal to determine net present value. Assume the stated discount rate is 14 percent annually. Use 7.00 percent semiannually throughout the analysis. (Disregard taxes.) (Assume the $2.10 million needed includes the underwriting costs. Input your present value of future payments answers as negative values. Do not round intermediate calculations and round your answers to 2 decimal places.)

b. Which plan offers the higher net present value?
  

The stockholders’ equity section of Ivanhoe Inc. at the beginning of the current year appears below. Common stock, $10 par value, authorized 1,063,000 shares, 281,000 shares issued and outstanding $2,810,000 Paid-in capital in excess of par—common stock 645,000 Retained earnings 589,000 During the current year, the following transactions occurred. 1. The company issued to the stockholders 95,000 rights. Ten rights are needed to buy one share of stock at $32. The rights were void after 30 days. The market price of the stock at this time was $34 per share. 2. The company sold to the public a $209,000, 10% bond issue at 104. The company also issued with each $100 bond one detachable stock purchase warrant, which provided for the purchase of common stock at $30 per share. Shortly after issuance, similar bonds without warrants were selling at 96 and the warrants at $8. 3. All but 4,750 of the rights issued in (1) were exercised in 30 days. 4. At the end of the year, 80% of the warrants in (2) had been exercised, and the remaining were outstanding and in good standing. 5. During the current year, the company granted stock options for 10,300 shares of common stock to company executives. The company, using a fair value option-pricing model, determines that each option is worth $10. The option price is $30. The options were to expire at year-end and were considered compensation for the current year. 6. All but 1,030 shares related to the stock-option plan were exercised by year-end. The expiration resulted because one of the executives failed to fulfill an obligation related to the employment contract.

Prepare general journal entries for the current year to record the transactions listed above. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Round intermediate calculations to 5 decimal places, e.g. 1.24687 and final answers to 0 decimal places, e.g. 5,125.)

The following information is provided for Starbucks (SBUX) and McDonalds (MCD) for the fiscal year (2017). All amounts are in millions of USD.

You are further given the following formulas:

Gross Margin = Gross Profit / Net Sales

Operating Margin = Operating Income / Net Sales

Return on Assets = Operating Margin x Total Asset Turnover

Current Ratio = Total Current Assets / Total Current Liabilities

Acid-Test Ratio = (Cash & Cash Equivalents + Short-term Investments + Accounts Receivable ) / Total Current Liabilities

Days' Sales Uncollected = Accounts Receivable / Net Sales x 365 days

Days' Sales in Inventory = Inventory / Cost of Goods sold x 365 days

Total Asset Turnover = Net Sales / Average Total Assets

Plant Asset Turnover = Net Sales / Average Plant Assets

REQUIRED: Answer the following Questions

1. Complete the table below to calculate the given ratios (Note: profitability ratios (the first three) need to be expressed as a percentage). All calculations to two decimal place

SBUXMCDPROFITABILITYGross Margin59.63%52.49%Operating Margin16.72% 31.45%Return on Assets26.08% 24.36%LIQUIDITYCurrent Ratio1.25 1.38Acid-Test Ratio0.84 1.22EFFICIENCYDays' Sales Uncollected14.19 23.26Days' Inventory Outstanding55.0815.47Total Asset Turnover1.56 0.77Plant Assets Turnover4.74 1.11

2. Answer the following questions by selecting the correct answer

(a) Which company is more effective in generating a return on its sales?

(Click to select)  MCD  SBUX  Neither

(b) What are some of the reasons that the company you chose above is  more effective in generating a return on its sales?

On average, SBUX has more customers than MCDunchecked

On average, SBUX has a higher markup on its cost of products than MCDchecked

On average, MCD has a higher markup on its cost of products than SBUXunchecked

On average, MCD has more customers than SBUXunchecked

(c) Which company is more effective in generating sales using its plant assets?

(Click to select)  SBUX  MCD

(d) Which company is more effective in generating sales using its total assets?

(Click to select)  MCD  SBUX

(e) What are some explanations for your answers in (c) and (d) above?

On average, SBUX has higher markup on its productschecked

SBUX leases more square footage than it ownsunanswered

On average, MCD has higher markup on its productsunanswered

MCD owns more square footage than it leasesunanswered

(f) Starbucks (SBUX) main coffee supplier requires a 60-day lead time when ordering inventory. Assume that today is January 10, 2018, using SBUX's Days' Sales in Inventory, when is the latest date that SBUX should order coffee? Explain your computations Please be detailed in your answer and use proper grammar

(g) On average. which company has a better accounts receivable management? Why? Please be detailed in your answer and use proper grammar

(h) Which company has a higher ability to pay off its short-term obligations as they fall due?

(Click to select)  MCD  SBUX

(i) What are some ways MCD can improve its receivables collection?

Offer cash discounts to accelerate its receivablesunanswered

Ask SBUX to collect its receivablesunanswered

Factor its receivablesunanswered

Negotiate a shorter waiting period from credit card companies using delayed paymentunanswered

Negotitate a longer waiting period from credit card companies using delayed paymentunanswered

Eliminate cash discounts for its credit customersunanswered

A description of workers. Each year, the Census Bureau selects a different and random sample of more than 3 million of households to be interviewed in American Community Survey (ACS). The dataset that have been assigned to you contains infor mation of a small random sample of workers of a particular state interviewed in the ACS 2016. I

Notes In your answers use up to one decimal place when the number is not an integer If the number is close to zero (i.e 0.0006) use up to four decimal places e Show your work to get full credit. When it corresponds, indicate what statistic unction of Excel you used to compute the estimate. Use the dataset that was assigned. If you use a different dataset, your homework will not be graded

(a) Describe the structure of the data set. In your answer include the population egorical (nominal/ordinal) or quantitative (discrete ,continuous), type of data (1.e., cross of interest, sample size, number of variables, type of variables (i.e. cat sectional, time series, or longitudinal data). (10 points)

(b) If each year the Census Bureau inter viewed the same sample of households, what would be the type of dataset generated by the ACS in this case? (3 pts). Explain.

(c) Use the earnings (WAGP) of the first ten workers to calculate the Σ and (-) (i.e. the sum of the squared deviations) of the workers earnings. Use to compute the sample mean and the sample standard deviation of these sums these workers' earnings. (10 pts)