Ask question

Ask question

All categories

3 years ago

10

In cell e5, enter a financial function to calculate the monthly payment. in cell e6, insert a financial function to calculate th

e cumulative total interest paid throughout the loan. make sure the results display as positive numbers.

1 answer:

eduard3 years ago

4 0

The excel function for monthly payments is =PMT()

The excel function for cumulative total interest is =CUMIPMT()

You might be interested in

Whenever a product line or a product family is extended, there is a risk of ________, which occurs when sales of an existing bra

xxTIMURxx [149]

Whenever a product line or a product family is extended, there is a risk of cannibalization, which occurs when sales of an existing brand decline as the firm's current customers switch to the new product.

<h3>What is a new product line?</h3>

This is term that is used to refer to the offering of a new product from a line that the company has not offered previously. It is the introduction of a new product entirely to the market.

Hence we have to say that Whenever a product line or a product family is extended, there is a risk of cannibalization, which occurs when sales of an existing brand decline as the firm's current customers switch to the new product.

Read ore on cannibalization here: brainly.com/question/17772125

#SPJ1

6 0

2 years ago

When qualifying a buyer using the Fannie Mae guidelines, what is the ratio allowed for the amount of money for housing expense c

vfiekz [6]

Answer:

28%

Explanation:

Most mortgage lenders, including Fannie Mae, use the 28/36 rule. That rule states that a family should spend no more than 28% of the gross monthly income (GMI) on housing expenses, and pay no more than 36% of GMI to cover debts (mortgage payments are included in this 36%).

Statistics show that households that do not comply with the 28/36 rule, tend to have difficulty paying back loans.

8 0

3 years ago

1. Prepare a contribution format income statement segmented by divisions. 2-a. The Marketing Department has proposed increasing

AURORKA [14]

Answer: Hello your question is incomplete below is the complete question

answer :

1) attached below

2a) Increases by $25,176

Explanation:

1) Attached below is the contribution format income statement

<u>2a) Determine by how much the net operating income will change </u>

monthly advertising increment = $25,000

Assumed increase in division's sales = 16%

first step : determine increment in contribution margin of west division

= 313,600 * 0.16 = 50,176

change in net operating income = 50176 - monthly advert increment

= 50176 - 25,000 = $25,176 ( increases )

8 0

3 years ago

Marc and Michelle are married and earned salaries this year of $64,000 and $12,000, respectively. In addition to their salaries,

stiks02 [169]

Answer:

I will use the 2020 tax schedule since recovery rebate credit applies to 2020:

Marc and Michelle's gross income = Marc's and Michelle's salaries + interest from corporate bonds = $64,000 + $12,000 + $500 = $76,500

they should choose the standard deduction since it is higher than their itemized deductions = ($24,400)

contribution to IRA = ($2,500)

<u>alimony payment = ($1,500) the divorce agreement was settled on 2005</u>

Marc and Michelle's taxable income = $48,100

Marc and Michelle's tax liability = $1,975 + [12% x ($48,100 - $19,750)] = $5,377

Interests on municipal bonds is not taxable.

The amount of taxes that they owe = $5,377 - $3,500 (federal tax withholdings) = $1,877

Refundable tax credits:

$2,000 in child tax credit

<u>$2,900 in recovery rebate credit</u>

total = $4,900

taxes payable or refund = tax liability - refundable tax credits = $1,877 - $4,900 = -$3,023.

Marc and Michelle should get a refund for $3,023

4 0

3 years ago

___ is how much the market can offer at different prices.

Brrunno [24]

Answer:

B.produksi

Explanation:

my indonesian

6 0

3 years ago

Read 2 more answers