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)

Ava is a first year staff accountant who is unsure of the difference between tests of controls and substantive testing. For each of the following tests, indicate whether it is more likely to be used as a TEST OF CONTROLS or as a SUBSTANTIVE TEST by choosing the appropriate answer.

Windsor Company acquired a plant asset at the beginning of Year 1. The asset has an estimated service life of 5 years. An employee has prepared depreciation schedules for this asset using three different methods to compare the results of using one method with the results of using other methods. You are to assume that the following schedules have been correctly prepared for this asset using (1) the straight-line method, (2) the sum-of-the-years'-digits method, and (3) the double-declining-balance method.

What is the cost of the asset being depreciated?

What amount, if any, was used in the depreciation calculations for the salvage value for this asset?

Which method will produce the highest charge to income in Year 1?

Which method will produce the highest charge to income in Year 4?

Which method will produce the highest book value for the asset at the end of Year 3?

If the asset is sold at the end of Year 3, which method would yield the highest gain (or lowest loss) on disposal of the asset?

Prior to adjustment at April 30, the end of the fiscal year, Salary Expense has a debit balance of $372,750. Salaries owed but not paid as of the same date total $5,275. On May 2, $6,000 is paid.

1. Present all necessary entries assuming a reversing entry is used.
2. Present all necessary entries assuming NO reversing entry is used.