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
Kray Inc., which produces a single product, has provided the following data for its most recent month of operations: Number of u
Allushta [10]

Answer:

The variable costing unit product cost was <u>$69.</u>

Explanation:

Variable Product Costing is a situation whereby only the variable costs of production is taking into account to estimating the cost per unit of a product. This implies that none of the fixed cost will be included in the cost of the product.

Based on the explanation above, the variable costing unit product cost to produce a single product by Kray Inc. can be calculated as follows:

Kray Inc.

Calculation of Variable Costing Unit Product Cost

<u>Particulars                                                          Amount ($)     </u>

Direct materials                                                        40

Direct labor                                                               19

Variable manufacturing overhead                           8

Variable selling and administrative expense     <u>     2      </u>

Variable cost per unit                                          <u>     69     </u>

Therefore, the variable costing unit product cost was <u>$69.</u>

5 0
3 years ago
The ___________ planning horizon is shorter than the aggregate production plan's, but must be longer than a firm's production le
klio [65]

Answer:

The correct answer is letter "B": Master production schedule.

Explanation:

A Master Production Schedule (MPS) is a detailed plan that outlines what products and in which quantities products should be manufactured over a certain period. This schedule contrasts the Aggregate Production Plan (APP) which has a broader scope in business production not only for a product but for a product family usually in large plants.

<em>MPS planning horizon is shorter than the APP but easier to understand assuming the demand for the product is constant. The MPS lead time to produce a good tends to be longer than the APP.</em>

7 0
4 years ago
What is the third primary decision when it comes to making financial decisions (along with spending and saving)?
Kaylis [27]
Setting your priorities could be a primary third desicion when it comes to making financial decisions.
8 0
3 years ago
Lucia Ltd. reported net income of $135,000 for the year ended December 31, 2016. January 1 balances in accounts receivable and a
tester [92]

Answer:

Lucia's cash flows from operating activities would be:

$132,000.

Explanation:

Accounts Receivable  End: $30,000  Beginning: $29,000 = -$1,000  

Accounts Payable    End: $24,000  Beginning: $26,000 = -$2,000  

Net Income : $ 135,000

To calculate the total cash flow from operating activities it's necessary to deduct of the Net Income the variance of these accounts which indicates a negative variance during the year, -$2,000 on accounts payable because the company paid more bills these year than before, and -$1,000 because the company expand their credit line to customers.

Cash Flow: $135,000 - $1,000 - $2,000 = $132,000.

4 0
3 years ago
Cigarette smokers are very loyal buyers of cigarettes. Even if prices of cigarettes rise, they will typically continue to buy th
Amanda [17]

Answer:

a. mostly cigarette buyers.

Explanation:

The law of demand states an inverse relationship between quantity demanded of a good and it's price, keeping other factors affecting demand as constant.

Price elasticity of demand refers to the degree of responsiveness of quantity demanded to a change in price.

Alcohol and cigarettes are exceptions to the law of demand since in their case, the factor of addiction presides which outweighs rational decision making.

Thus, price elasticity of demand of cigarettes is inelastic. So a marginally higher price charged for cigarettes will not reduce their consumption.

A new tax on cigarettes would raise their prices. The manufacturers, to cover such taxes and maintain the same margin as before would further raise the prices of cigarettes further.

Thus, the tax burden would be shifted to the consumers and hence majorly borne by them.

3 0
3 years ago
Other questions:
  • On Monday morning you sell one June T-bond futures contract at 97:27, that is, for $97,843.75. The contract's face value is $100
    8·1 answer
  • Which organization sets monetary policy for the United States?
    12·2 answers
  • When the price of a bond is above the equilibrium price, there is excess ___ in the bond market and the price will ___.
    9·1 answer
  • Marigold Corp. showed the following balances at the end of its first year:
    8·1 answer
  • Robert is including a description of the construction industry and the main competitors in his area in his business plan for a c
    15·1 answer
  • The __________ job market is comprised of internet job boards, want ads, newspaper ads, and radio advertisements. these are medi
    14·1 answer
  • Ceilings are thought to represent the level at which more difficult questions would not be passed.
    5·1 answer
  • The balance of​ stockholders' equity at the beginning of the year and the end of the year was $ 60 comma 000 and $ 67 comma 000​
    8·1 answer
  • 360-degree feedback Select one: a. is designed to provide feedback for promotion or pay decisions. b. is designed to deal with a
    15·1 answer
  • Because of the substitution problem, the cpi tends to overstate the true change in the price of the typical basket of consumer g
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!