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
jasenka [17]
3 years ago
14

The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required an

alysis to answer the questions below.
a. Complete an amortization schedule for a $29,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 9% compounded annually. Round all answers to the nearest cent.
Beginning Repayment Ending
Year Balance Payment Interest of Principal Balance
1 $ $ $ $ $
2 $ $ $ $ $
3 $ $ $ $ $
b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all answers to two decimal places.

% Interest % Principal
Year 1: % %
Year 2: % %
Year 3: % %
c. Why do these percentages change over time?
a. These percentages change over time because even though the total payment is constant the amount of interest paid each year is declining as the remaining or outstanding balance declines.
b. These percentages change over time because even though the total payment is constant the amount of interest paid each year is increasing as the remaining or outstanding balance declines.
c. These percentages change over time because even though the total payment is constant the amount of interest paid each year is declining as the remaining or outstanding balance increases.
d. These percentages change over time because even though the total payment is constant the amount of interest paid each year is increasing as the remaining or outstanding balance increases.
e. These percentages do not change over time; interest and principal are each a constant percentage of the total payment.
Business
1 answer:
algol133 years ago
4 0
A=2610 you didn’t show the question but I help for nomber one
You might be interested in
Priscilla decides to order a delivery from the local sandwich shop. Her order comes to $12. 74 and there is a $2. 30 delivery ch
DochEvi [55]

Debit is the amount of the money paid or owed, it can either raise the asset amount or can reduce the equity balances. It can also be referred to as the amount spent as an expense from the account.

$ 16.95 is the total debit amount.

<h3>How to calculate Priscilla's debit?</h3>

Given,

  • Price of the order = $12.74
  • Delivery charge = $2. 30

Step 1: The 15% of the total price of the order excluding delivery will be:

\begin{aligned}15\% &= \dfrac{\rm X}{\$12.74} \times 100\\&#10;\\&#10;\rm X &= \dfrac{\$12.74 \times 15}{100}\\&#10;\\&#10;& = \$1.91\end{aligned}

Step 2: Add the total price of the order, delivery charge and tip.

\$12.74 + \$ 2.30 + \$ 1.91 = \$16.95

Therefore, option c. $ 16.95 is the expected debit from her account.

Learn more about debit here:

brainly.com/question/3591182

4 0
2 years ago
A straight bill of lading is most likely to be used under which of the following circumstances?
Lina20 [59]

A straight bill of lading is most likely to be used when the shipment is to an affiliate.

In keeping with finance management, a straight bill of lading is a document wherein a seller concurs to apply a specific shipping option to ship goods to a sure vicinity, and the invoice is then assigned to a mainly named consignee.

A straight bill of Lading is a non-negotiable invoice of lading. it's miles used when the goods which can be being brought are already paid for or are donations or presents and don't require a charge. The usage of this, the consignee is delivered the products via the delivery business enterprise upon presentation of identification.

The difference between a straight bill of lading and a reserve invoice of lading is the fee fame of the products being shipped. An instant invoice of lading is issued when the goods have been paid for in advance by way of the consignee to the shipper.

Learn more about bills here brainly.com/question/15339309

#SPJ9

4 0
2 years ago
Mariposa Corporation is considering purchasing equipment for $200,000. Mariposa expects this equipment will last for 20 years an
Westkost [7]

Answer:

$24,220

Explanation:

After tax cashflow formula as follows;

AT cashflow = Income before taxes(1- tax) + annual depreciation amount

Depreciation amount is added back because even though it is an expense deducted to arrive at the income before tax, it is not an actual cash outflow.

Annual depreciation amount = $200,000/ 20 = $10,000

AT cashflow = 18,000*(1-0.21) + 10,000

= 14,220 + 10,000

= 24,220

Therefore, Mariposa’s expected cash flow after taxes per year is $24,220

6 0
3 years ago
The cost structures of a monopoly have ____________ relationships among fixed costs, variable costs, marginal costs, and average
Ksju [112]

The cost structures of a monopoly have the same relationships among fixed costs, variable costs, marginal costs, and average cost values as pure competition.

Profits for the monopolist, like all organization, can be identical to total revenues minus total costs. The sample of costs for the monopoly may be analyzed inside the identical framework because the costs of a perfectly competitive firm—that is, with the aid of using using total cost, fixed cost, variable cost, marginal cost, average cost, and average variable cost.

However, due to the fact a monopoly faces no competition its situation and its choice method will fluctuate from that of a superbly aggressive organization.

<h3>What is Monopoly Price?</h3>

A monopoly price is set by a monopoly. A monopoly occurs when a firm lacks any viable competition and is the sole producer of the industry's product. Because a monopoly faces no competition, it has absolute market power and can set a price above the firm's marginal cost. Since marginal cost is the increment in total cost required to produce an additional unit of the product, the firm can make a positive economic profit if it produces a greater quantity of the product and sells it at a lower price.

Learn more about Monopoly on:

brainly.com/question/7217942

#SPJ4

8 0
2 years ago
True or false: gross domestic product (gdp) measures total expenditures on final goods and services during a given period of tim
Fittoniya [83]

That statement is True.

The purpose of calculating Gross Domestic Product is to measure the market value of all the goods and services that produced by a country within a specific time period.

Gross Domestic Product is calculated using this formula:

Consumption + Gross Investment + Government investment + (Exports - Imports)

6 0
3 years ago
Read 2 more answers
Other questions:
  • Will feckless unexpectedly inherits $10,000 from a rich uncle. he is observed to consume fewer hamburgers than he used to.
    13·1 answer
  • 2. Which of the following regarding the stock indices is true?
    9·1 answer
  • An entrepreneurial team consists of: A. managers with similar skills, abilities, and interests.B. experienced professionals from
    12·1 answer
  • How are bonds rated? how are these rating helpful to the investors?​
    12·1 answer
  • Two towns, each with three members, are deciding whether to put on a fireworks display to celebrate the New Year. Fireworks cost
    15·1 answer
  • the winner of the first annual Tom Morris Golf Invitational won $130 in the competition which was held in 1904. In 2015, the win
    10·1 answer
  • Paul sells one parcel of land (basis of $100,000) for its fair market value of $160,000 to a partnership in which he owns a 60%
    11·1 answer
  • Assume that the corporate tax rate is 34% and the personal tax rate is 30%. The founders of a newly formed business are debating
    5·1 answer
  • Haley, a single taxpayer, owns and operates a Cafe (as a sole proprietorship). The business is not a specified services business
    14·1 answer
  • The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales an
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!