Use the Housing Interest Rate database (see DATA at bottom of this question)

In this part using Housing Interest Rate database, the objective is to compare the variation in the FIXED_RATE between two periods; before 2000 and after year 2000.

• i) Using descriptive statistics measures to interpret the shape of FIXED_RATE variable, calculate any outlier(s) finally verify whether if the empirical rule applies to the FIXED_RATE distribution.  Use an appropriate graph to confirm your findings.

• ii) Use a random generating procedure to draw a random sample of size 80 with respect to the “before and after year 2000 “factor.  Indicate which sampling method you used.  Using your sample data, calculate which period shows more variation in the FIXED_RATE.  Using the sample data, what is the   sampling error of FIXED_RATE?

I WILL GIVE YOU THUMBS UP AND EXCELLENT REVIEWS FOR HELP/GUIDANCE WITH THIS. ANY HELP WILL BE GREATLY APPRECIATED! THANK YOU!

DATA:

Kollar Company, a publicly traded corporation, has a defined benefit pension plan. Pension Information concerning this plan for the fiscal year 2017 is presented below: Information provided by the plan’s actuary:

• DBO as of December 31, 2016 $1,800,000

• Past service reduction from plan amendment on January 2, 2017 300,000

• Current service costs for 2017 520,000 • Payments to retirees in 2017 400,000

• Changes in actuarial assumptions at December 31, 2017 resulting in an actuarial loss 45,000

• Discount rate used on DBO for 2017 6%

Information provided by the plan’s trustee:

• Plan asset balance on January 1, 2017 $1,600,000

• 2017 contributions 540,000

• 2017 actual return on plan assets 180,000

• Expected long-term rate of return on plan assets 6%

Required: Write neatly and show all your work.

(a) Prepare a continuity of all pension-related accounts for the year 2017, using either the worksheet format or the continuity format, at your preference. (b) Prepare the pension-related journal entry(ies) at December 31, 2017. (c) Identify the plan’s funded status. (d) How would this plan be shown on the December 31, 2017 Statement of Financial Position? (e) For this part, assume that Lumnar uses ASPE. Provide the note disclosure at December 31, 2017.

Need to choose a publicly traded company. Using the most recent SEC 10-k or Annual report, the Company I chose is Under Armour and the information is provided in the SEC website for 2018 & 2019; however I am unable to locate and calculate the information requested below in the website. : Please help.

Provide the Company's cash balance for the past 2 years.

Provide the Company's accounts receivable for past 2 years.

Identify the Note that discusses 'Cash and cash equivalents' and summarize it.

Identify the Note(s) relevant to accounts receivable and discuss the key accounting policies.

Discuss the allowance for doubtful accounts.

Provide the Company's inventory balance for the past 2 years.

Discuss the Company's policies for reporting inventory.

Compute the AR turnover and Days Outstanding for Receivable.

Compute the Inventory turnover and Days Sales in Inventory.

You are the current "up-and-coming" corporate controller for a publicly traded company called Spartan Cruises, Inc. and as such, report to the CFO Tom Harris who in turn reports to the CEO Michele Lowry.

Spartan Cruises, headquartered in Miami, offers upscale cruises primarily to US citizens out of three ports as follows:

1.      15 ships operating out of Miami with Caribbean itineraries that are very profitable.

2.      10 ships operating out of Barcelona Spain with Mediterranean itineraries that are modestly profitable.

3.      5 ships operating out of Sydney Australia with Australian coast and New Zealand itineraries that are effectively break even from a financial perspective.

All 30 ships cost approximately $150.00 million/ship and are depreciated on a straight line basis over 10 years (with no residual or salvage value) - the 15 operating out of Miami are relatively new, the 10 operating out of Barcelona are 5 years old, and the 5 ships operating out of Sydney are much older and fully depreciated.

In addition, Spartan Cruises had previously signed contracts to purchase 3 additional ships at $150.0 million/ship that were scheduled to be delivered to Miami in mid-2022 but as of today, construction has not commenced. As part of the contract signing process for each ship, Spartan Cruises made a good-faith non-refundable deposit of $20.0 million/ship and recorded a combined asset of $60 million on their balance sheet.

Late last week, CFO Tom and CEO Michele attended a high-level economic summit in New York City and during the conference, credible market experts predicted that the cruise industry is about to go through permanent economic contraction and as such, will no longer enjoy the demand and revenue levels it enjoyed in recent years. Specifically, the experts predict that cruise industry revenues will be 70% lower than what the industry was otherwise anticipating over the next five years due primarily to the pandemic vulnerability passengers are exposed to as evidenced by the recent well-publicized coronavirus (something Spartan Cruises was fortunate to totally avoid).

On the private plane ride back from New York, Tom and Michele discussed how Spartan Cruises was going to adapt to this new reality given that the Barcelona & Sydney operations will probably become very unprofitable as incoming cash flow from cruise sales is expected to effectively evaporate.

Tom and Michele are considering discontinuing the Barcelona and Sydney operations, and cancelling the orders for the 3 new ships, and have asked you to quantify on a macro perspective what the financial impact would be if the Spartan Cruises Board of Directors decided to move in that direction and announce these discontinued operations before the end of the March 31 first quarter.

Q1.

what the effect might be for reflecting these "impairment issues" into the March 31, 2020 first quarter income statement

Q2.

other financial considerations that management might take into account when deciding on this potential action.

Over a decade ago, Enron was a high flying publicly traded company. It’s stock had soared and created tremendous wealth for many employees and stockholders alike. The financial statements for Enron that were disclosed as part of their SEC filings were highly complex. A whistleblower within Enron led to disclosures that revealed fraud ultimately leading to its bankruptcy and collapse. Employees lost their jobs. Shareholders lost vast fortunes. Several executives went to jail. And Arthur Andersen, a leading accounting firm, had its name dragged through the mud as an accomplice to the fraud leading to the ultimate demise of that entire accounting firm. Should we expect accountants to uncover fraud and be an early warning signal? Do you think auditors are just “rubber stamps” for the management of public companies? In general do you think we can trust the financial statements released by public companies? In cases where a public company has to restate it's financial statements, should the blame be with the accountants or the management? Explain.

Barnaby Corp., a publicly traded company, had the following capital structure on
January 1, 20X4:

Common shares — 1,000,000 issued and outstanding $15,000,000
Series A cumulative preference shares with an annual dividend of $2.50
per share — 90,000 issued and outstanding
5,000,000
4% Series B non-cumulative preference shares — 100,000 issued and
outstanding
11,250,000
2.3% Series C non-cumulative, convertible preference shares which are
convertible into common shares at the rate of two common shares for each
preference shares, at the holder’s option — 50,000 issued and outstanding
$1,750,000
During 20X4, the following capital transactions occurred:
• On March 1, Barnaby issued 160,000 common shares for $5,600,000. Legal and
other fees related to this issue totalled $210,000. Barnaby uses the offset method to
recognize issuance costs.
• On November 1, Barnaby acquired land with an estimated fair market value of
$1,200,000. In lieu of cash, Barnaby issued 65,000 common shares as consideration
for the land when the shares were trading at $18.50 per share.
Dividends were last paid in 20X0. On December 1, 20X4, Barnaby declared dividends
totalling $2,239,000, which will be paid to shareholders of record on January 2, 20X5.

Required:
a) Prepare the journal entries for all the share transactions that occurred during 20X4.


b) Calculate the total amount of dividends to be paid to each class of shares.

c) Prepare the journal entries to record the declaration of the dividends. (1 mark)

On January 1, 2018, Marx Corporation, a publicly traded company, had these shareholders’ equity accounts:

During the year, the following transactions occurred:

Consider the following capital structure for Sea Shore Corporation. The company has a publicly-traded bond issue, preferred shares, and common equity in its capital structure. The firm’s tax rate is 35%. The risk-free rate is 7%.

Details on the components of the capital structure are listed below.

Sea Shore’s weighted average cost of capital (wacc) is closest to:

A) 7.62%

B) 8.51%

C) 9.87%

D) 10.14%

1. XYZ corp is a private company without publicly traded equity. you need to determine what XYZ's equity Beta would be if the company decided to go public. XYZ target equity ratio is 75%. below are XYZ 3 closet competitors.
             
Alsace.     Beta=1.44.   debt ratio=0.54
Parasol.   Beta=1.12.    debt ratio=0.22
Univex.     Beta=1.36.    debt ratio=0.42

what is XYZ expected equity beta?

2. assume that risk free rate of 1.55% and an equity market risk premium of 5.5%,what is XYZ equity cost of capital(re)? if you were unable to calculate XYZ in question 1,use a beta 1.21 for this calculation.

3. assume XYZ cost of debt is 200 basis points over the risk free rate,what is XYZ WACC? use tax rate of 25%. if you didn't calculate re in question 2 ,use 7.5 as XYZ equity capital.

4. what happens to XYZ WACC if tax rate increase to 35% . what generalization can you make about the relationship between corporate tax rate and company's WACC?

5. debt is cheaper that equity, so if XYZ changed its target equity ratio from 75% to 65% would reduce XYZ's WACC? why or why not? what happens to the cost of debt as leverage is increase?how does leverage affect equity beta?

please try to answer all my questions. its very important.