1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
34kurt
3 years ago
7

In cell G5, enter a formula to calculate the total amount due for the first client based on the annual total and the number of y

ears in the contract. Copy the three formulas in columns C, G, and E down their respective columns.
Business
1 answer:
Brilliant_brown [7]3 years ago
5 0
The answers for your question are: 
1) =E5*F5 (copy to cells G6:G13) 

<span>2) =VLOOKUP(B5,Membership,3,FALSE) </span>

<span>3) =PMT(B$23/B$24,F5*B$24,-I5)</span>
You might be interested in
Gore Global is considering the two mutually exclusive projects below. The cash flows from the projects are summarized below.
d1i1m1o1n [39]

Answer:

D

Explanation:

Internal rate of return is the discount rate that equates the after tax cash flows from an investment to the amount invested

IRR can be calculated with a financial calculator  

Flying Car

Cash flow in year 0 = -$200,000

Cash flow in year 1 = 50,000

Cash flow in year 2 = 50,000

Cash flow in year 3 =80,000

Cash flow in year 4 =100,000

IRR = 13%

To find the IRR using a financial calculator:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. After inputting all the cash flows, press the IRR button and then press the compute button.  

7 0
3 years ago
A listing of all possible returns on an investment, with a chance of occurrence assigned to each return is known as _____.
Anna35 [415]
Answer: Probability Distribution
4 0
3 years ago
Coastal Shores Inc. (CSI) was destroyed by Hurricane Fred on August 5, 2021. At January 1, CSI reported an inventory of $170,000
Fofino [41]

Answer:

$65,000

Explanation:

Calculation to determine what The estimated inventory loss due to Hurricane Fred would be

Beginning inventory$170,000

Add Net purchases195,000

Goods available for sale365,000

($170,000+$195,000)

Less: Cost of goods sold (300,000)

($480,000/160%)

Estimated ending inventory$65,000

($365,000-$300,000)

Therefore The estimated inventory loss due to Hurricane Fred would be $65,000

8 0
3 years ago
QS 9-8 (Algo) Recording employer payroll taxes LO P3 Merger Co. has 10 employees, each of whom earns $1,700 per month and has be
oksian1 [2.3K]

Answer:

Dr Payroll Tax Expense: $2,321

Cr FICA- Social security taxes payable $1,054

Cr FICA- Medicare taxes payable $247

Cr SUTA-State unemployment taxes payable $918

Cr FUTA- Federal unemployment taxes payable $102

Explanation:

Preparation of the March 31 journal entry to record the March payroll taxes expense

March 31

Dr Payroll Tax Expense: $2,321

($1,054+$247+$918+$102)

Cr FICA- Social security taxes payable $1,054

[($1,700*10)*6.2%]

Cr FICA- Medicare taxes payable $247

[($1,700*10)*1.45%]

Cr SUTA-State unemployment taxes payable $918

[($1,700*10)*5.4%]

Cr FUTA- Federal unemployment taxes payable $102

[($1,700*10)*0.6%]

(To record payroll taxes expense)

5 0
3 years ago
Consider a hypothetical closed economy in which households spend $0.75 of each additional dollar they earn and save the remainin
Nata [24]

Answer and Explanation:

According to the scenario, computation of the given data are as follow:-

1) Marginal propensity to consume (MPC) for this economy is 0.75 as it denotes the spending of the household and saving of 0.25 and the spending multiplier for this economy is

= Spending Multiplier(M)

= 1 ÷ 1 - MPC

= 1 ÷ 1-0.75

= 1 ÷ 0.25

= 4

2). Decrease in government purchases will lead to a decrease in income, generating an initial change in consumption

= -Amount of Government Decrease Purchases by × MPC

= -$250 billion × 0.75

= -$187.5 billion

3). Decrease income again, causing a second change in consumption

= Amount Decrease in Government Purchases × MPC

= -$187.5 billion × 0.75

= $140.6 billion

4).Total change in demand resulting from the initial change in government spending

=  Amount of Government Decrease Purchases by × Spending Multiplier(M)  

= $250 × 4

= $1,000 billion

= $1 trillion

As we can see that the income falls by $1000 billion in the end, so AD shifts to the left by the size of $1 trillion

In the question the graph is missing. Kindly find the attachment for both of question and answer

5 0
3 years ago
Other questions:
  • Filter the data in place so that only rows where the category value is meals and the cost value is greater than 20 are shown. th
    14·1 answer
  • Suppose you have taken out a $400,000 fully amortizing fixed-rate mortgage loan that has a term of 15 years and an interest rate
    12·1 answer
  • Acme published a story about paul and as a result paul sued acme for damage to his reputation, emotional distress, and punitive
    9·2 answers
  • Kirstie’s boss asks for input about ways the company can improve its current advertising campaign. However, every time an employ
    12·1 answer
  • Eastline Corporation had 13,500 shares of $5 par value common stock outstanding when the board of directors declared a stock div
    15·1 answer
  • Notes Receivable Entries The following data relate to notes receivable and interest for Owens Co., a financial services company.
    9·1 answer
  • Accounting is the information system that A. measures business activity. B. communicates the results to decision makers. C. proc
    7·1 answer
  • A group of ten UIC professors each contributed an equal amount to the purchase of a State of Illinois Lottery ticket. Two of the
    13·1 answer
  • Burger21 is a chain of fast-food restaurants that got its start in Tampa, Florida. In order to increase sales, the company has o
    13·1 answer
  • The city of Jacksonville, Florida is issuing $100,000,000 of general obligation bonds paying interest on January 1st and July 1s
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!