tanley-Morgan Industries adopted a defined benefit pension plan on April 12, 2021. The provisions of the plan were not made etroactive to prior years. A local bank, engaged as trustee for the plan assets, expects plan assets to earn a 10% rate of return. The ctual return was also 10% in 2021 and 2022.* A consulting firm, engaged as actuary, recommends 5% as the appropriate discount ate. The service cost is $300,000 for 2021 and $390,000 for 2022. Year-end funding is $310,000 for 2021 and $320,000 for 2022. lo assumptions or estimates were revised during 2021. We assume the estimated return was based on the actual return on similar investments at the inception of the plan and that, since the stimate didn't change, that also was the actual rate in 2022. equired: alculate each of the following amounts as of both December 31, 2021, and December 31, 2022: (Enter your answers in thousands .e., 200,000 should be entered as 200).) 1. 2. 3. 4. Answer is complete but not entirely correct. December 31, 2021 Projected benefit obligation Plan assets Pension expense Net pension asset or net pension liability $ $ $ $ December 31, 2022 0X $ 0X $ $ 10,000 $ 300,000 705,000 X 661,000 X 674,000 X 44,000 X

The answer 417,974.94 was correct. Can you please help me solve without technology? Formulas used, etc. Thank you!

What does the QuickBooks Online Check Register do?

Using Excel, create a table that shows the relationship between the interestearned and the amount deposited, as shown. we will first create the dollar amount column and the interest row, as shown . Next we will type into cell B3 the formula = $A3*B$2. We can now use the Fill command to copy the formula in other cells, resulting in the table as shown. Note that the dollar sign before A3 means column A is to remain unchanged in the calculations when the formula is copied into other cells. Also note that the dollar sign before 2 means that row 2 is to remain unchanged in calculations when the Fill command is used.

Hi, Could you please show me how to solve this with formulas? not excel, I should have clarified. Thanks

The first part of the assignment is to open Excel and in column A starting in row 1 and down to row 40 generate random values using the RAND() function. Copy and special paste those values onto sheet2. You will turn in the Excel file, but you will use the information below when directed. Say an individual is faced with the decision of whether to buy auto insurance or not (like before laws in many states changed). The states of nature are that no accident occurs (with probability .992) or an accident occurs (with probability .008). Here is the payoff table for the decision maker (where -500 is read minus 500, for example) State of Nature Decision No Accident Accident Purchase insurance -500 -500 Do not purchase Ins. 0 -10000 1. Say the individual is a RISK LOVER. Create a table with plausible values of utility for the risk lover where you pick as the indifference probability for the value -500 the first value that is appropriate from your simulation in Excel (starting in cell A1 on…