Sachs Brands' defined benefit pension plan specifies annual retirement benefits equal to: 1.2% × service years × final year's salary, payable at the end of each year. Angela Davenport was hired by Sachs at the beginning of 2004 and is expected to retire at the end of 2038 after 35 years' service. Her retirement is expected to span 18 years. Davenport's salary is $80,000 at the end of 2018 and the company's actuary projects her salary to be $230,000 at retirement. The actuary's discount rate is 6%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.)

Required:
2. Estimate by the projected benefits approach the amount of Davenport's annual retirement payments earned as of the end of 2018.
3. What is the company's projected benefit obligation at the end of 2018 with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)
4. If no estimates are changed in the meantime, what will be the company's projected benefit obligation at the end of 2021 (three years later) with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)

Sachs Brands' defined benefit pension plan specifies annual retirement benefits equal to: 1.3% × service years × final year's salary, payable at the end of each year. Angela Davenport was hired by Sachs at the beginning of 2004 and is expected to retire at the end of 2038 after 35 years' service. Her retirement is expected to span 18 years. Davenport's salary is $81,000 at the end of 2018 and the company’s actuary projects her salary to be $235,000 at retirement. The actuary's discount rate is 7%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.)

Required:

2. Estimate by the accumulated benefits approach the amount of Davenport’s annual retirement payments earned as of the end of 2018.

3. What is the company’s accumulated benefit obligation at the end of 2018 with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)

4. If no estimates are changed in the meantime, what will be the accumulated benefit obligation at the end of 2021 (three years later) when Davenport’s salary is $95,000?

(Do not round intermediate calculations. Round your final answer to nearest whole dollar.)

Suppose the following data were collected relating the selling price of a house to square footage and whether or not the house is made out of wood. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average wood houses are more expensive than other types of houses at the 0.05 level of significance? If yes, type the regression equation in the spaces provided with answers rounded to two decimal places. Else, select "There is not enough evidence." Selling Prices of Houses Price Sqft Wood (1 if wood, 0 if otherwise) 185821 2004 1 246288 3691 1 224158 2975 1 247893 3339 0 205153 2649 0 168477 1566 0 231917 3324 1 177916 1768 1 201064 2336 1 161010 1386 0 225514 3026 1 222100 3384 0 217999 3119 1 174755 1939 0 210379 2861 0 196333 2400 0 177035 1513 1 171289 1831 0 159158 1763 0 229969 3361 1 Answer How to enter your answer Selecting a checkbox will replace the entered answer value(s) with the checkbox value. If the checkbox is not selected, the entered answer is used

Suppose the following data were collected relating the selling price of a house to square footage and whether or not the house is made out of wood. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average wood houses are more expensive than other types of houses at the 0.05 level of significance? If yes, type the regression equation in the spaces provided with answers rounded to two decimal places. Else, select "There is not enough evidence." Selling Prices of Houses Price Sqft Wood (1 if wood, 0 if otherwise) 185821 2004 1 246288 3691 1 224158 2975 1 247893 3339 0 205153 2649 0 168477 1566 0 231917 3324 1 177916 1768 1 201064 2336 1 161010 1386 0 225514 3026 1 222100 3384 0 217999 3119 1 174755 1939 0 210379 2861 0 196333 2400 0 177035 1513 1 171289 1831 0 159158 1763 0 229969 3361 1 Answer How to enter your answer Selecting a checkbox will replace the entered answer value(s) with the checkbox value. If the checkbox is not selected, the entered answer is used.

Sachs Brands’ defined benefit pension plan specifies annual retirement benefits equal to: 1.6% × service years × final year’s salary, payable at the end of each year. Angela Davenport was hired by Sachs at the beginning of 2004 and is expected to retire at the end of 2038 after 35 years’ service. Her retirement is expected to span 18 years. Davenport’s salary is $90,000 at the end of 2018 and the company’s actuary projects her salary to be $240,000 at retirement. The actuary’s discount rate is 7%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.)

Required:
2. Estimate by the projected benefits approach the amount of Davenport's annual retirement payments earned as of the end of 2018.
3. What is the company's projected benefit obligation at the end of 2018 with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)
4. If no estimates are changed in the meantime, what will be the company's projected benefit obligation at the end of 2021 (three years later) with respect to Davenport? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)

Maria is an investor and over the years has acquired and disposed of a number of assets. She has kept records of all these transactions. During the year ended 30 June 2020, Maria disposed of several assets. As a result of these disposals, she made a number of capital gains and losses:

Profit on sale of trading stock $15000   

Loss on Disposal of motor vehicle $(5000)

Gain on Disposal of vacant block of land (acquired 1/9/19) $17000

Gain on sale of shares $4525

Loss on sale of shares $(2630)

Loss on Disposal of the caravan (cost $25000) $(5000)

Loss on Disposal of the antique watch (cost $4000) $(560)

Gain on Disposal of the investment property (acquired 24/12/2004) $162000

Capital losses carried forward from previous years:

Loss on Disposal of painting $1200

Loss on Disposal of Shares $12000

All assets, other than the land, had been owned by Maria for more than 12 months and had been acquired since December 1999.

Required:

Calculate the net capital gain that Maria should include in her tax return for the year ended 30 June 2020 and any losses that can be carried forward to future years.

Hans is a body-builder who owns and operates a health club in Freedonia, where he teaches body-building, weight-lifting, and strength exercises. In 1995, Hans wrote and obtained a copyright for a body-building manual entitled Pump You Up. In 2019, Hans learned that Franz, who lives and works in Sylvania (a state located 1,500 miles from Freedonia), was selling photocopies of Pump You Up over a website for profit without permission. Franz sold several copies of Pump You Up to Freedonia residents, gross Freedonia sales only $500.00 from 2004 to 2019.

Hans sues Franz in Freedonia court for copyright infringement, claiming that Franz is subject to personal jurisdiction in Freedonia bassed on Freedonia’s long-arm statute, which reads:

“A court may exercise personal jurisdiction over any non-domiciliary, or his executor or administrator, who in person or through an agent, transacts any business within the state or contracts anywhere to supply goods or services in the state.”

Franz has no office, employees, property, or bank accounts in Freedonia.

Does the Freedonia court have personal jurisdiction over Franz, making him subject to the lawsuit?

The admissions data for freshmen at a college in the past 10 years are as follows:

1. Plot the number of applications.
2. Develop a trend model to forecast the number of applications for next year. Calculate the R² of that model and the estimated number of applications for the next year.
3. Plot the percentage of acceptances relative to the number of offers made (acceptance yield).
4. Develop a trend model to forecast next year’s acceptance yield. Calculate the R² of that model and the estimated yield for next year.
5. Assume that the college is planning for an entering class of 5,000 freshmen for each of the next two years and a class of 5,300 in the following year. What is the number of offers it should make in each year? Is it getting tougher to get into this college?

use excel AND SHOW EXCEL FORMULAS

Assume that your uncle holds just one stock, East Coast Bank (ECB), which he thinks has very little risk. You agree that the stock is relatively safe, but you want to demonstrate that his risk would be even lower if he were more diversified. You obtain the following returns data for West Coast Bank (WCB). Both banks have had less variability than most other stocks over the past 5 years.

Year                 ECB                  WCB

2004                 40.00%            40.00%

2005 -              10.00%            15.00%

2006                 35.00%            -5.00%

2007                 -5.00%             -10.00%

2008                 15.00%            35.00%

a. What is the expected return and risk of each stock?

b. Measured by the standard deviation of returns, by how much would your uncle's risk have been reduced if he had held a portfolio consisting of 60% in ECB and the remainder in WCB? In other words, what is the difference between portfolio's standard deviation and weighted average of components' standard deviations? (Hint: check the example on page 11-12 on my note).

If this problem can be done using excel, in a way that I can understand the steps I need to take as I go.