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
VARVARA [1.3K]
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.
Business
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
Today, you turn 21. Your birthday wish is that you will be a millionaire by your 40th birthday. In an attempt to reach this goal
JulsSmile [24]

Answer:

rate of 0.000171716533316905 = 0.017% daily

Explanation:

we need to solve for the rate of an annuity for 19 years with daily deposits of 75 dolllars to yield a principal of 1,000,000 dollars

365 days x 19 years = 6,935 days

we use goal seek on excel as follow:

on A1 we write 0.01 this will be a placeholder for the rate

then on A2 we write  =FV(A1;6935;75)

then with goal seek we definethat we want A2 equal to 1,000,000 changing A1 (rate)

which give us:

0.000171717  = 0.017% per day to achieve the goal:

C \times \frac{(1+r)^{time} -1}{rate} = FV\\  

C 75

time 6935

rate 0.000171717

75 \times \frac{1-(1+0.000171716533316905)^{-6935} }{0.000171716533316905} = FV\\  

FV $999,999.9999  

5 0
3 years ago
If a university decreases the price of tickets to football games to collect more revenue, it is assuming that the demand for tic
Ksivusya [100]
Higher because there is reduction in the list price of tickets for football games.
3 0
3 years ago
You own a portfolio of two stocks, a and
Furkat [3]
Stock a is $2000. Calculate 10.5% of $2000, which equals $210.
Stock b is $3000. Calculate 14.7% of $3000, which is $441.

The expected return on the portfolio is $210 + $441, which equals $651. 
7 0
3 years ago
In general, education is correlated to income
liq [111]

Answer:

positively.

Explanation:

The <u><em>correlation </em></u>between education and income is positive a more educated person will always have a better income than one that is not. But along the statistical distribution of this<u><em> correlation</em></u> there are people that <u><em>deviate </em></u>for the curve <u><em>(standar deviation)</em></u>  and even though they are educated they do not earn as much money to others that have the same level of education.

3 0
3 years ago
Read 2 more answers
A company has annual sales of $160 million, a net profit margin of 4%, and total assets of $90 million. It carries $10 million i
sasho [114]

Answer:

18.29%

Explanation:

Return on Equity is the net profit available for equity/ Total equity value.

Total equity = Total assets - Total debt

= $90 million - $55 million = $35 million

Earnings for equity = Annual sales \times net profit margin 4%

= $160 million \times 4% = 6.4 million

Therefore, return on equity = \frac{Net\ profit\ for\ equity}{Total\ value\ of\ equity}

= \frac{6.4\ million}{35\ million} \times 100 = 18.2857

Therefore, ROE = 18.29%

4 0
3 years ago
Other questions:
  • Prepare an adjusted trial balance as of December 31. (Enter your answers in thousands of dollars.) MINT CLEANING INC. Adjusted T
    7·1 answer
  • LeGrand Corporation reported the following amounts in its income statement: Sales revenue $ 440,000 Advertising expense 60,000 I
    8·1 answer
  • JDW Corporation reported the following for 20X1: net sales $2,929,500; cost of goods sold $1,786,995; selling and administrative
    10·1 answer
  • Ms. Anderson has $60,000 income this year and $40,000 next year. The market interest rate is 10 percentper year. Suppose Ms. And
    14·1 answer
  • 1. What is the impact of government created price ceilings on the market place?
    6·1 answer
  • The following scenario applies to the next three questions. At the start of the current period, Alberich Jewelers had an invento
    13·1 answer
  • Pronghorn Corporation shipped $20,800 of merchandise on consignment to Gooch Company. Pronghorn paid freight costs of $2,200. Go
    6·1 answer
  • T or F #7 QUICK
    6·1 answer
  • From the consumer’s perspective, the elements of an imc strategy can be viewed as being either.
    15·1 answer
  • As per the nisp guideline, an incubation unit at the institute can take up to what % of total equity in an incubated startup in
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!