jkurenn

17.04.2021 • 

Business

On January 1 of this year, Shannon Company completed the following transactions (assume a 9% annual interest rate): (FV of $1, PV of $1, FVA of $1, and PVA of $1) a. Bought a delivery truck and agreed to pay $61,600 at the end of three years.
b. Rented an office building and was given the option of paying $11,600 at the end of each of the next three years or paying $29,600 immediately.
c. Established a savings account by depositing a single amount that will increase to $93,200 at the end of seven years.
d. Decided to deposit a single sum in the bank that will provide 9 equal annual year-end payments of $41,600 to a retired employee (payments starting December 31 of this year).
1. What is the cost of the truck that should be recorded at the time of purchase?
2. Which option for the office building results in the lowest present value?
a. Pay in a single instalment.
b. Pay in three instalments.
3. What single amount must be deposited in this account on January 1 of this year?
4. What single sum must be deposited in the bank on January 1 of this year?

Ответ:

cheyennebatz3609

04.01.2023

Business

---

The correct formula will be :

=average(past event tab then col in that tab) use this for att, programs, food, and merch

=AVERAGE('Past Events'!C4:C103)

Explanation:

To calculate the correlation between the sales of each kind of product and event attendance, from the Input analysis part of the spreadsheet model.

According to the information provided, in the targeted cell, we will use formula

=Average(data cells)

and for other part of the question is to calculate sales. For this part we can simply use the sum formula, first, we will sum the sales for a single item in past events column than at the end of the past column.

Thus, the correct formula will be :

=average(past event tab then col in that tab) use this for att, programs, food, and merch

=AVERAGE('Past Events'!C4:C103)

---

0,0(0 оценок)