Problem ABC is a young starup company. Currently, they do not pay dividends. The first scheduled dividend will be paid at the end of year 3, with amount of $1.50. In the next 4 years, the dividend will grow at 20% every year. After that, it will maintain a sustainable growth rate of 6% forever. The required rate of return is 15%. John hired you as an excel programmer. He asks you to write only one flexible excel program that has all of the following requirements respect to the change of input data: a) The amount of stock price must be shown at “answer section” ( 1 point) b) Please use IF function to develop a fexible model displaying the stock price and dividend for this model.

Analyze, Discuss and base properly

Question num. one

Of all the personal and professional attributes that a covenant negotiator must have, which do you consider to be the most important and significant that you must possess? Prepare a list of the attributes that a negotiator should have and indicate the most important in your opinion and why.

Question num. 2

Collective bargaining has long been viewed by scholars as an "art." More recently, however, scholars have begun to see collective bargaining as a "science." Explain your position on this statement. Indicate whether you agree or disagree and say why. Be detailed in your answer. Because some think it is an art and others think it is a science.

Question num. 3

From an employer's point of view, what advantages and disadvantages do you see in reducing a grievance to a formal written complaint. Do you consider that a verbal complaint is better than a formal written complaint? Be specific about the advantages and disadvantages of each modality. Do not forget that your opinion is requested from the employer's point of view

Question num. 4

Why might the management of a company or the union itself prefer not to have an arbitration clause contained in a negotiated collective agreement? What use is arbitration? Do you consider arbitration to be a useful tool for conflict resolution? You would recommend negotiating a collective agreement that does not contain an arbitration clause. Be highly specific in your opinion.

Question num. 5

Generally, collective agreements contain clauses regarding wages and the subsequent adjustments that must be made during the term of the agreement. If you are a union representative and are negotiating an agreement, what would be the elements related to wages that you would negotiate for the benefit of your enrollment. What compensation elements would you include in your agreement as part of your salary definition. What if any would you suggest to address gradual wage increases, namely: percentage increases, performance-based increases, increases based on some economic formula, or increases based on government determinations? Would you prefer a combination of factors? As structuring its clauses related to wages. Be highly specific. Do not forget that you are a representative of the workers.

Tommy has recently graduated from SUSS and has joined a well-known retailer that operates 3 department stores in Singapore. His job function is that of a business analyst. It has been well-reported that retail business in Singapore is on the decline and his employer would like to determine if the forecast for the next few years will be equally bad. Tommy has been tasked to perform the analysis and his output will provide insights in the company's hiring and expansion plan in Singapore.

The first thing Tommy did was to download the Retail Sales Index data from the Department of Statistics Singapore website. He specifically extracted the data for "Department Stores" from Q1 2008 to Q4 2018. (2017 is set as the base year with Index = 100). Refer to data below:

Year/Quarter Retail Sales Index (Department Stores)

2008 1Q 92.4

2008 2Q 93

2008 3Q 84.9

2008 4Q 105.3

2009 1Q 87.1

2009 2Q 88.6

2009 3Q 83.2

2009 4Q 103.6

2010 1Q 94.3

2010 2Q 93.9

2010 3Q 90.7

2010 4Q 109.3

2011 1Q 99.6

2011 2Q 99

2011 3Q 95.8

2011 4Q 119.3

2012 1Q 104.9

2012 2Q 99.9

2012 3Q 95

2012 4Q 117

2013 1Q 106.1

2013 2Q 100.9

2013 3Q 97.5

2013 4Q 118.6

2014 1Q 107.1

2014 2Q 98.7

2014 3Q 95.7

2014 4Q 117.6

2015 1Q 108.2

2015 2Q 101.1

2015 3Q 98.8

2015 4Q 114.4

2016 1Q 103.8

2016 2Q 93.9

2016 3Q 93.2

2016 4Q 112.9

2017 1Q 100.3

2017 2Q 93

2017 3Q 94.6

2017 4Q 112.1

2018 1Q 102.7

2018 2Q 92.3

2018 3Q 93.6

2018 4Q 112.8

(a) Use the techniques of time series modelling and with justifications, discuss the considerations on how Tommy would forecast the quarterly Retail Sales Index in 2019 and 2020.

(b) Upon confirmation of the forecast technique to undertake in Part 3(a), determine the quarterly RSI forecast in 2019 and 2020. You are required to show the essential steps in deriving the forecast and comment on any limitations of your technique.

Accounts receivable transactions are provided below for J Pharoah Co.

Dec. 31, 2020 The company estimated that 4% of its accounts receivable would become uncollectible. The balances in the Accounts Receivable account and Allowance for Doubtful Accounts were $661,000 and $2,700 (debit), respectively.

Mar. 5, 2021 The company determined that R. Mirza’s $3,500 account and D. Wight’s $6,900 account were uncollectible. The company’s accounts receivable were $691,400 before the accounts were written off.

June 6, 2021 Wight paid the amount that had been written off on March 5. The company’s accounts receivable were $650,600 prior to recording the cash receipt for Wight.

1) Post the journal entries to Allowance for Doubtful Accounts and calculate the new balance after each entry. Allowance for Doubtful Accounts Date Explanation Ref. Debit Credit Balance Dec. 31, 2020 Balance unadjusted Debit Dec. 31, 2020 AJE Mar. 5, 2021 Write off Mirza Mar. 5, 2021 Write off Wight June 6, 2021 Reverse write off

Suppose that you are a dealer in sugar. On 26^th March 2020 you hold 200,000 pounds of sugar in inventory that is worth $0.0379 per pound. The current price of a futures contract expiring 3 months later in June is $0.0450 per pound. Each futures contract is written on 100,000 pounds of sugar. You have decided to sell two June 2020 futures contract to hedge your planned sale of sugar later. Assume a zero interest rate so that you can ignore the cost of any initial margin or variation margins. The futures contract is cash settled.

Required:

1. Calculate the original basis. Also calculate your net proceeds (from both the sale of sugar and the cash settlement of the futures contract if settlement of the futures contract takes place on the mandatory close out date). Assume the “type” of sugar and the sugar quality that underlies the futures contract exactly matches the physical sugar you hold as part of your inventory. Original Basis is: ? Net proceeds from sugar sale and settlement of any gain or loss on the two futures contract at maturity date or the mandatory close out date of the futures contract is: ?
2. Now assume that the sugar is sold and the hedge is closed on 10^th April 2020, when the spot price is $0.0474 and the June 2020 futures price is $0.0490. Calculate the net proceeds from both the sale of sugar and the cash settlement of the two futures contracts on 10^th April 2020.

Pop Inc. reported income from continuing operations before taxes during 2020 of $463,000.

Additional transactions occurring in 2020 follows:

1. The corporation experienced an uninsured hurricane loss in the amount of $130,000 during the year.

2. At the beginning of 2018, the corporation purchased equipment for $62,000 (salvage value of $6,000) that had a useful life of 10 years. The bookkeeper used straight-line depreciation for 2018, 2019, and 2020 but incorrectly used a 7 year useful life in determining the deprecation amount. (treat this error as a prior period adjustment)

3. Sale of securities held as a part of its portfolio resulted in a gain of $40,000 (pretax).

4. When its chairman of the board died, the corporation realized $500,000 from an insurance policy. The cash surrender value of this policy had been carried on the books as an investment in the amount of $410,000 (the gain is nontaxable).

5. The corporation disposed of its consumer division at a loss of $210,000 before taxes. Assume that this transaction meets the criteria for discontinued operations.

6. The corporation decided to change its method of inventory pricing from average cost to the FIFO method. The effect of this change on prior years is to increase 2018 income by $86,000 and increase 2019 income by $43,000 before taxes. The FIFO method has been used for 2020. The tax rate on these items is 30%.

Instructions: Prepare an income statement in good form for the year 2020, starting with income from continuing operations before taxes.

Compute earnings per share as it should be shown on the face of the income statement.

Common shares outstanding for the year are 200,000 shares. (Assume a tax rate of 30% on all items, unless indicated otherwise.)

Blossom Corporation has one temporary difference at the end of 2020 that will reverse and cause taxable amounts of $54,000 in 2021, $58,900 in 2022, and $64,300 in 2023. Blossom’s pretax financial income for 2020 is $272,300, and the tax rate is 30% for all years. There are no deferred taxes at the beginning of 2020.

A. Compute taxable income and income taxes payable for 2020.

B. Prepare the journal entry to record income tax expense, deferred income taxes, and income taxes payable for 2020. (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.)

C.

Prepare the income tax expense section of the income statement for 2020, beginning with the line “Income before income taxes.”. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).)

Zekany Corporation would have had identical income before taxes on both its income tax returns and income statements for the years 2018 through 2021 except for differences in depreciation on an operational asset. The asset cost $200,000 and is depreciated for income tax purposes in the following amounts: 2018 $ 66,000 2019 88,000 2020 30,000 2021 16,000 The operational asset has a four-year life and no residual value. The straight-line method is used for financial reporting purposes. Income amounts before depreciation expense and income taxes for each of the four years were as follows. 2018 2019 2020 2021 Accounting income before taxes and depreciation $ 110,000 $ 130,000 $ 120,000 $ 120,000 Assume the average and marginal income tax rate for 2018 and 2019 was 30%; however, during 2019 tax legislation was passed to raise the tax rate to 40% beginning in 2020. The 40% rate remained in effect through the years 2020 and 2021. Both the accounting and income tax periods end December 31. Required: Prepare the journal entries to record income taxes for the years 2018 through 2021. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)

Zekany Corporation would have had identical income before taxes on both its income tax returns and income statements for the years 2018 through 2021 except for differences in depreciation on an operational asset. The asset cost $190,000 and is depreciated for income tax purposes in the following amounts:

  
The operational asset has a four-year life and no residual value. The straight-line method is used for financial reporting purposes.
  
Income amounts before depreciation expense and income taxes for each of the four years were as follows.
   

  
Assume the average and marginal income tax rate for 2018 and 2019 was 30%; however, during 2019 tax legislation was passed to raise the tax rate to 40% beginning in 2020. The 40% rate remained in effect through the years 2020 and 2021. Both the accounting and income tax periods end December 31.
   
Required:
Prepare the journal entries to record income taxes for the years 2018 through 2021. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)