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
How many 1/16 are in 3/4 of an imch
Goryan [66]
I'd say 12/16 is the answer
4 0
3 years ago
Read 2 more answers
Mark Crane purchased a $1,000 corporate bond five years ago for $1,055. The bond paid 7.0 percent annual interest. Five years la
lys-0071 [83]

Answer:

Mr Crane's total return on the bond investment was 5.35%

Explanation:

The return on a bond is also known as it yield to maturity (YTM). In order to find a bonds YTM we need to know its present value, future value, coupon payments and number of years. In this case the bond's present value is 1,055 because it was bought at this price, it's future value is 980 because it was sold for 980, its number of years was 5 as it was held for 5 years and its coupon payment was  (0.07*1000)=70. Now in order to compute return or ytm we need to put all these values in a financial calculator and compute I

PV= -1055

FV= 980

PMT= 70

N=5

Compute I=5.35

The return on the bond investment was 5.35%

6 0
3 years ago
A manufacturer of hospital supplies has a uniform annual demand for 320 comma 000 boxes of bandages. It costs ​$10 to store one
mash [69]

Answer:

100 times per year

Explanation:

Data provided in the question:

Annual Demand , D = 320,000 boxes

Cost of storing one box, C = $10

Plant set up cost for production, c = $160

Now,

The optimal ordering quantity = \sqrt\frac{2cD}{C}

or

The optimal ordering quantity = \sqrt\frac{2(160)(32,000)}{10}

or

= 3200

Therefore,

Number of timer in year company produce boxes = \frac{\textup{Demand}}{\textup{Optimal order quantity}}

= \frac{\textup{320,000}}{\textup{3,200}}

= 100 times per year

4 0
3 years ago
The weather station model performs the invaluable function of ____________.
Greeley [361]

Answer:

Option B                                    

Explanation:

In simple words, Models of weather stations are visual representations displaying the weather taking place at a specified monitoring station. The stations design was developed by meteorologists that incorporate a variety of climate components into some kind of small area on satellite images.This model has been of high use to prepare for the natural calamtites in advance but it does not influence the project in any way.

4 0
3 years ago
Cullumber Company uses the percentage-of-receivables basis to record bad debt expense. Accounts receivable (ending balance) $605
Lana71 [14]

Answer:

a. Journal entry

b. $18,150

c. $586,850

Explanation:

a. The adjusting journal entry is as follows

Bad debt expense A/c Dr

  To Allowance for doubtful debts

(Being bad debt expense is recorded)\

The computation of the bad debt expense is shown below:

= Account receivable × estimated percentage given  + debit balance of allowance for uncollectible accounts

= $605,000 × 3% + $4,700

= $18,150 + $4,700

= $22,850

b. The adjusted balance in Allowance for Doubtful Accounts is $18,150

c. The cash realizable value is

= $605,0000 - $18,150

= $586,850

8 0
3 years ago
Other questions:
  • The following information pertains to Guy’s Gear Company: Sales $ 75,000 Expenses: Cost of Goods Sold $ 47,500 Depreciation Expe
    8·1 answer
  • Quote from the scenario four challenges faced by the music industry
    14·1 answer
  • Which of the following arguments about job analysis is most effective in order to gain the support of top managers? Group of ans
    5·1 answer
  • Jane receives an email claiming that her bank account information has been lost and that she needs to click a link to update the
    6·1 answer
  • Zephyros Corporation had estimated manufacturing overhead costs for the coming year to be $301,000. The total estimated direct l
    8·1 answer
  • Suppose that initially a bank has excess reserves of $800 and the reserve ratio is 20%. Then Andy deposits $1,000 of cash into h
    5·1 answer
  • Explain the functions of a trade union. (6)
    14·2 answers
  • Teal Mountain Industries produces a product that requires 2.6 pounds of materials per unit. The allowance for waste and spoilage
    9·1 answer
  • In the BCG Matrix, cash cows are: _____________
    11·1 answer
  • Why do economists pay attention to the balance of trade?
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!