(a) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, exponential) to the time series. (A negative value should be indicated by a minus sign. Do not round the intermediate calculations. Round your final answers to 2 decimal places.)

(b) Use each of the three fitted trend equations to make numerical forecasts for the next 3 years. (Round the intermediate calculations to 2 decimal places and round your final answers to 1 decimal place.)

T Linear| Exponential | Quadratic

9 _________ _________ _________

10 _________ _________ _________

11 _________ ___________ _________

Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of? 1000, 25 years to maturity, and a coupon rate of 6.4 percent paid annually. If the yield to maturity is 7.5 percent, what is the current price of the bond?

______price?

USING UNITED STATES IBC CHAPTER 7:

1. Roofing inter-layment shall have a minimum width of ____ inches.

A. 12                           B. 18                           C. 34                           D. 36

2. What is the minimum roof covering classification for a roof assembly on a building of Type IA construction?

A. Class A                   B. Class B                   C. Class C                   D. Non-classified

3. Roof assemblies consisting of metal sheets of shingle are considered ____ as roof assemblies.

A. A                            B. B                             C. C                             D. Special purpose

4. Double underlayment application is required beneath asphalt shingles on roofs having a maximum slope of ______.

A. 2:12                        B. 3:12                        C. 4:12                        D. 5:12

5. In areas subject to high winds, underlayment beneath asphalt shingles shall be fastened along the overlap at a maximum spacing of ____ inches.

A. 12                           B. 18                           C. 24                           D. 36

6. Define the following terms as per code:
     a. Built-up roof covering:

     b. Positive roof drainage:

     c. Scupper:

     d. Roof recover

7. List the test(s) that are used to measure the wind resistance of asphalt shingles.

8. Describe a product that meets the material requirements for wood shingles in roof

9. For built-up roofs, what test standard is used for the use of asphalt in roof?

10. Describe the code requirement in an area where there is a history of ice-forming along the eaves.

USING UNITED STATES IBC CHAPTER 8:

1. Define the following:
   a. Shallow Foundation:
   
   b. Expansive Soil:

c. Foundation Drain:

2. Describe the situations when a sub-surface investigation for Ground-Water table is required and when it can be waived.

3. In the absence of a load-bearing test for foundation to be built on a crystalline bedrock, a vertical foundation pressure up to _______ may be used in design.
   
   A. 3000 psf                                 B. 4000 psf                          C. 6000 psf                          D. 12000 psf

4. For concrete used in foundation, the specified minimum compressive strength should be _________.  
   
   A. 3000 psi                                  B. 3500 psi                          C. 4000 psi                          D. 5000 psi
   
5. For precast pre-stressed deep foundations elements, the concrete cover must be at least _____ inches.

A. 1.5 inches                              B. 2.0 inches                       C. 2.5 inches                       D. 3.0 inches     

6. The minimum depth of a footing placed below undisturbed ground surface shall be _____ inches.

A. 12 inches                                B. 15 inches                        C. 18 inches                        D. 24 inches

7. Code waives the frost protection requirement of foundation for a free-standing building with maximum area of ______.

A. 400 sq. ft.                               B. 600 sq. ft.                       C. 800 sq. ft.                       D. 1000 sq. ft.

8. In the absence of design, the width of concrete footing supporting a 2-story light-frame construction shall be accepted to be _______.

A. 12 inches                                B. 15 inches                        C. 18 inches                        D. 24 inches

9. The edge thickness of plain concrete footings supporting walls other than light-frame construction shall not      
      be less than _______.

A. 6 inches                                  B. 8 inches                          C. 10 inches                        D. 12 inches

           10.   For Type ____ buildings, timber footings are allowed by the code.

     A. Type II                                        B. Type III                            C. Type IV                            D. Type V

Please Convert yearly data to quarterly data on excel

Income Level

Canada United States

Year Annual Annual

2000 22750 59938

2001 23110 58609

2002 23580 57947

2003 25480 57875

2004 29530 57674

2005 34300 58291

2006 37890 58746

2007 41530 59534

2008 44930 57412

2009 43220 57010

2010 44480 55520

2011 47180 54673

2012 51080 54569

2013 52800 56479

2014 52190 55613

2015 47580 58476

2016 43940 60309

2017 43000

2018 44860

1. Which 4 were the worst ideas? & Why? Crystal Pepsi, Ben-Gay Asprin, XFL United States Football League, Coca Cola Blak, Law Enforcement Bikes, Microsoft WebTV Plus, Pepsi AM, Maxwell House Brewed Coffee, Coca Cola Coke, & Frito Lay

2. Assess the possibilities of success from some relatively new products. This is not based on whether you like the product or not, its your assessment as to whether it can be successful and what needs to happen to ensure that it is successful.  In your write up, include specific target market(s).You are assessing 3 of them.

(Nair for Men), (Blk Water) & (True Lemon)

On January 1, 2018, Pomegranate Company acquired 90% of the voting stock of Starfruit Company for $91,700,000 in cash. The fair value of the noncontrolling interest in Starfruit at the date of acquisition was $6,300,000. Starfruit’s book value was $13,000,000 at the date of acquisition. Starfruit’s assets and liabilities were reported on its books at values approximating fair value, except its plant and equipment (10-year life, straight-line) was overvalued by $25,000,000. Starfruit Company had previously unreported intangible assets, with a market value of $40,000,000 and 5-year life, straight-line, which were capitalized following GAAP.

Additional information: Pomegranate uses the complete equity method to account for its investment in Starfruit on its own books. Goodwill recognized in this acquisition was impaired by a total of $2,000,000 in 2018 and 2019, and by $500,000 in 2020. It is now December 31, 2020, the accounting year-end.

Here is Starfruit Company’s trial balance at December 31, 2020:

Dr (Cr)

Current assets $28,200,000

Plant & equipment, net 188,000,000

Intangibles 2,000,000

Liabilities (180,000,000)

Capital stock (1,000,000)

Retained earnings, January 1 (29,500,000)

Acumulated other comprehensive income, January 1 (500,000)

Dividends 400,000

Sales revenue (24,000,000)

Cost of goods sold 10,000,000

Operating expenses 6,500,000

Other comprehensive income (100,000)

$ 0

Question: On the 2020 consolidation working paper, eliminating entry (R) reduces the Investment in Starfruit by

$ 3,600,000

$64,800,000

$68,200,000

$81,000,000

Case Study: The Reveton Ransomware Attacks

In August 2012, the Internet Crime Complaint Center (IC3), a partnership between the FBI and the National White Collar Crime Center, was inundated with reports of a new type of cybercrime. Victims across the United States reported that while searching the Internet, their computers locked up, and they received the following message, purportedly from the FBI: “This operating system is locked due to the violation of the federal laws of the United States of America! (Article 1, Section 8, Clause 8; Article 202; Article 210 of the Criminal Code of U.S.A. provides for a deprivation of liberty for four to twelve years.)” The message then accused the victim either of visiting pornography Web sites or of distributing copyrighted content. Victims were told they could unlock their computers and avoid prosecution by paying a fine of $200 within 72 hours of receiving the message. The message came replete with the official FBI logo.

The incident pointed to a steep rise in ransomware attacks. Ransomware is malware that disables a computer or smartphone until the victim pays a fee, or ransom. Unlike other viruses, the Reveton version of ransomware is not activated by opening a file or an attachment. Rather it is an example of “drive-by malware,” viruses that download automatically when a user visits an infected Web site.

The FBI immediately issued an alert, but within a month, cybersecurity experts had identified 16 variants of the ransomware. These viruses had infected 68,000 unique IP addresses. It is estimated that on an average day, about 170 victims paid the $200 fee and received valid unlock codes. The compromised computers could not be fixed through the installation or updating of antivirus software because the computer was locked. Because so many home PC owners fail to back up their systems regularly, many victims faced losing a significant amount of data. The $200 fee itself was low enough to encourage payment. A visit to a professional IT service to repair the damage could potentially cost the same amount and take more time to resolve. A quick payment through a prepaid money card system, such as MoneyPak, could save the victim a lot of trouble.

The United States was not the first country to be hit by these attacks. In early 2012, criminal gangs targeted France, Germany, and the United Kingdom. Ransomware attacks first broke out in Russia in 2009. Since that time, they have spread to almost every country on the globe, hitting the United States and Japan especially hard. Symantec, an IT security company, estimates that gangs are extorting over $5 million per year from online victims. The rise of ransomware attacks is, no doubt, due in part to their success. In France, for example, almost 4 percent of victims coughed up the ransom money during a non-Reveton scam.

The Reveton ransomware is delivered by the popular Russian-language Citadel malware toolkit. The latest version of Citadel can also grab passwords from Web browsers and change Web sites to trick users into handing over their login information.

In December 2012, the United Kingdom arrested three people they believed were involved in the Reveton ransomware attacks. Finding the perpetrators, however, is unusual and is not the most effective way to combat this crime. Law enforcement agencies and IT security companies have urged the public to take

measures to prevent themselves from falling victim to such attacks—by keeping software such as Java, Acrobat Reader, Adobe Flash, Windows, and their browser software updated. An early Reveton ransomware attack made use of a vulnerability in a version of Java that had just been patched a month prior. Computer users can also avoid infections by using security software that identifies suspicious Web sites, and by not clicking online ads from dubious companies. Perhaps, however, the best way to avoid the spread of these attacks is to encourage victims to report the crime and to refuse to comply with the ransom demands.

Questions:

1. Why are ransomware attacks on the rise?
2. What can you do to prevent ransomware attacks on your own computer?
3. How do you think victims should respond to ransomware attacks?
4. Do the victims have an ethical obligation to future victims? If yes, why? If no, why?

Assume the tax rate for each company is 25% in all years. Any tax effects should be adjusted through the deferred tax liability account.

1. Fleming Home Products introduced a new line of commercial awnings in 2020 that carry a one-year warranty against manufacturer’s defects. Based on industry experience, warranty costs were expected to approximate 2% of sales. Sales of the awnings in 2020 were $2,900,000. Accordingly, warranty expense and a warranty liability of $58,000 were recorded in 2020. In late 2021, the company’s claims experience was evaluated, and it was determined that claims were far fewer than expected: 1% of sales rather than 2%. Sales of the awnings in 2021 were $3,400,000, and warranty expenditures in 2021 totaled $77,350.
2. On December 30, 2017, Rival Industries acquired its office building at a cost of $880,000. It was depreciated on a straight-line basis assuming a useful life of 40 years and no salvage value. However, plans were finalized in 2021 to relocate the company headquarters at the end of 2025. The vacated office building will have a salvage value at that time of $640,000.

Required:
For each situation:
1. Identify the type of change.
2. Prepare any journal entry necessary as a direct result of the change, as well as any adjusting entry for 2021 related to the situation described.