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
Which is the best answer
Ipatiy [6.2K]
The answer would be between A and D.
3 0
3 years ago
Identify and discuss the “needs” of a society.
sweet [91]

A traditional list of immediate "basic needs" is food (including water), shelter and clothing. Many modern lists emphasize the minimum level of consumption of 'basic needs' of not just food, water, clothing and shelter, but also sanitation, education, and healthcare.

7 0
3 years ago
You are thinking of purchasing a house. The house costs $350,000. You have $50,000 in cash that you can use as a down payment on
jeyben [28]

Answer:

$63,852

Explanation:

The computation is shown below:

a) PV of payments is

= $23,500 × (1.07^30 - 1) ÷ (0.07 × 1.07^30)

= $2,91,612

b) The Loan PV of payments is $3,00,000

c) And, the Balloon payment required is

= (Borrowed amount - loan PV payments) × (1 + rate of interest)^number of years

= ($300,000 - $291,612) × 1.07^30

= $63,852

5 0
3 years ago
On January 1, Year 1, Johnston Company purchased a 40% interest in the common stock of Truly Inc. for $100,000. Johnston has sig
e-lub [12.9K]

Answer:

$112,000

Explanation:

The Equity method shall be used in this question for determining book value of investment made by the Johnston company in Truly Inc because the investment gives the Johnston company the significant influence over the Truly Inc.

Under equity method, the book value of investment made by the Johnston company as at end of year 1 shall be determined as follow:

Amount invested initially                                 $100,000

Add: Net income for the year                          $20,000

(50,000*40%)

Less: dividends received                                 ($8,000)

(20,000*40%)    

Book value of investment at end of year 1      $112,000

5 0
3 years ago
A $250,000 loan is to be amortized over 8 years, with annual end-of-year payments. Which of these statements is CORRECT? a. If t
Anarel [89]

Answer:

The answer is "Option b".

Explanation:

In this scenario, the second option, which would be the percentage within each transaction that's also interest instead of the full amount, would've been lower if the rate of interest were lower because interest-related transactions would have been higher at lower rates and conversely, as opposed to the main refunds.

7 0
3 years ago
Other questions:
  • In an imperfectly competitive labor market, the cost of labor inputs and the value of the products sold will _________ vary as m
    5·1 answer
  • Layla Company began making mascara in November 2018 using a single-step process. Layla incurred $42,000 for materials and $48,64
    15·1 answer
  • The Finishing Department had 5,000 incomplete units in its beginning Work-in-Process Inventory which were 100% complete as to ma
    13·1 answer
  • Choose the correct description of variable and fixed costs. A. A variable cost is related to a particular cost object and can be
    9·1 answer
  • Which of the following will shift the aggregate demand curve to the left?
    11·1 answer
  • You purchased 50 shares of a stock at $100 per share. Your stock value dropped 5% in one year. If the stock were to continue to
    11·2 answers
  • Marketing strategies A) enable marketing managers to be satisfied just planning present activities. B) ensure that every opportu
    7·1 answer
  • Financial resources are also known as what?
    11·1 answer
  • The first person that answers ill give u 50 brainlist points, brainlist to, stars, and a heart
    11·2 answers
  • Name any three (3) tests that Hornbill Holdings can use to assess the graduates
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!