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
Pie
3 years ago
8

Casey wants to calculate the monthly payments for each loan option that he is considering. Switch to the Loan Options worksheet.

In cell B12, create a formula using the PMT function to calculate the monthly payments for loan Option A. Use the values in cells B8, B10, and B5 for the Rate, Nper, and Pv arguments, respectively, and do not enter any values for the optional arguments. Copy the formula you created in cell B12 into the range C12:D12.
Business
1 answer:
taurus [48]3 years ago
6 0

Answer:

= PMT(B8/12,B10,B5)

Explanation:

The excel PMT function is calculated using the following formula

PMT(rate, nper, pv, [fv], [type])

Where rate = rate of payments per month

nper = duration of payment in month

pv = Present Value

fv = future value (it's an optional field)

type = payment type (it's an optional field)

Given that

B8 = rate

B10 = nper

B5 = pv

In cell B12, type the following

= PMT(B8/12,B10,B5)

We're making use of B8/12 because we need the rate to be in months not years.

Since there are 12 months in a year, monthly rate = B8/12

To use this formula in C12:D12

Use the following;

In cell C12, type the following

= PMT(C8/12,C10,C5)

In cell D12, type the following

= PMT(D8/12,D10,D5)

You might be interested in
Jamison Company had sales revenue and operating expenses of $5,000,000 and $4,200,000, respectively, for the year just ended. If
Evgesh-ka [11]

Answer:

A,. 13.33%.

Explanation:

Return on Investment (ROI) which gives the efficiency of a particular investment

We were given invested capital amounted as $6,000,000, and operating expenses as $5,000,000

We can calculate net income by substracing equal sales revenue from operating expenses

net income can be calculated as = ($5000000-$420000)

= $800000

ROI can be calculated as

net income/Capital investment

$800000/$6000000

=. 13.33%.

4 0
3 years ago
gdp is the best measurement of a country's economy. explain why you agree or disagree with this statement
Sonja [21]
GDP is designed to assess the production of goods in a market economy by output. However, it is not efficient in accounting for public and private services that without output that are easily countable by the number of units produced. GDP is not also well suited in measuring improvements in the diversity and quality of goods and services. It is also poor in estimating the depletion of resources. Finally, it doesn't also reflect the degradation of the environment involved in the production process.
3 0
3 years ago
Let’s suppose you would like to buy a home for $250,000. But like most U.S. citizens, you don’t have enough cash on hand to pay
noname [10]

Answer:

1. Calculate the monthly payment for a 30-year mortgage loan.

we can do this by using the present value of an annuity formula

the loan's interest rate is missing, so I looked for a similar question and found that it is 6%

present value = monthly payment x annuity factor

monthly payment = present value / annuity factor

  • present value = $200,000 (loan's principal)
  • PV annuity factor, 0.5%, 360 periods = 166.79161

monthly payment = $200,000 / 166.79161 = $1,199.101082 ≈ <u>$1,199.10</u>

2. Calculate the amount of interest that you’d pay for a 30-year mortgage loan.

total interests paid during the 30 years = (monthly payment x 360) - principal = ($1,199.10 x 360) - $200,000 = <u>$231,676</u>

8 0
3 years ago
Which one of the following would not be considered an advantage of the corporate form of organization?a. Limited liability of ow
solmaris [256]

Answer:

Disadvantage of Corporate Form of Organization:

d. Government regulation

Explanation:

In recent times, government regulation of businesses appears to be regarded as a disadvantage of the corporate form of organizations.  Governments intervene and regulate corporate entities whenever they fail to be self-regulatory.  But, the regulations may appear to be so much that the corporate form of organization now looks like a disadvantage.  Given the many corporate scandals, collapses, and misapplications of resources by corporate entities that have become the order of the day, government regulation is very important.  Without government regulation, many corporate bodies will not be acting in the public interest.  This is more so with public entity corporate organizations with diverse stakeholders and corporate managers who act as if they were running their own autonomous governments.

5 0
3 years ago
Mason Automotive is an automotive parts company that sells car parts and provides car service to customers. This is Mason's firs
miv72 [106K]

Answer:

1) Mason Automotive sells 10,000,000 shares at $5 par for $30 on January 1st, 2018.  

Dr Cash 300,000,000

   Cr Common stock 50,000,000

   Cr Additional paid in capital 250,000,000

2) Ed Mason, the CEO, hires 3,000 employees, whom will receive a combined salary of $12 Million on a monthly basis. The employees started on January 1st and will be paid for the month of January on February 5th. Employee's withholdings are as follows: 10% for federal income taxes 5% for state income taxes and 7% for FICA. Record the necessary entry as of January 1st, 2019.          

No journal entry required

Adjusting entry:

January 31, 2018, wages expense

Dr Wages expense 12,000,000

Dr FICA taxes expense 840,000

   Cr Federal income taxes withheld payable 1,200,000

   Cr State income taxes withheld payable 600,000

   Cr FICA taxes withheld payable 840,000

   Cr FICA taxes payable 840,000

   Cr Wages payable 9,360,000

3) Mason Automotive issues a bond payable on January 1st, 2018 with a face value of $200 Million at 102. The bond will have a useful life of 5 years with an interest payment of 5% (Annual Percentage Rate) due at the end of the month. Record the necessary journal entry as of January 1st,  2018.

Dr Cash 204,000,000

   Cr Premium on bonds payable 4,000,000

   Cr Bonds payable 200,000,000

(Note: When considering the amortization of the discount or premium, assume the straight line method is used).  

Adjusting entry        

January 31, 2018, interest expense

Dr interest expense 766,666.66

Dr Premium on bonds payable 66,666.67

   Cr Interest payable 833,333.33

4) Mason Automotive purchased $80 Million dollars worth of inventory on January 2nd, 2018. $80 Million was paid with cash with the remaining balance on account. Mason notes that it will use a perpetual inventory system to track inventory.  

Dr Inventory 80,000,000

       Cr Accounts payable 80,000,000      

5) Mason Automotive purchases fixed assets of $120 Million that will have a useful life of 10 years and no salvage value on January 2, 2018. $20 million was paid with cash with the remaining balance on account. These assets are depreciated using the straight-line method.  

Dr Fixed assets 120,000,000

   Cr Cash 20,000,000

   Cr Accounts payable 100,000,000

Adjusting entry:

January 31, 2019, depreciation expense  

Dr Depreciation expense 1,000,000

   Cr Accumulated depreciation - fixed assets 1,000,000    

6) On January 2nd, Mason Automotive shipped an order to Corby Panther Company. The shipping terms were FOB shipping point and the value of the order was $50 Million and the inventory cost was $20 Million. Assume that this sale was made on account.          

Dr Accounts receivable 50,000,000

   Cr Sales revenue 50,000,000

Dr Cost of goods sold 20,000,000

   Cr Inventory 20,000,000

Adjusting entry:

January 31, 2018, allowance for doubtful accounts (5%)

Dr Bad debt expense 2,500,000

   Cr Allowance for doubtful accounts 2,500,000

7) On January 3, Mason Automotive receives $75 Million advance payment from a customer, Michael Scott Paper Company, to manufacture 7,500 cars.        

Dr Cash 75,000,000

   Cr Deferred revenue 75,000,000

Adjusting entry:

January 31, 2019, 4,000 cars were finished and delivered

Dr Deferred revenue 40,000,000

   Cr Sales revenue 40,000,000

Dr Cost of goods sold 32,000,000

    Cr Inventory: finished cars 32,000,000

8) Mason Automotive buys a patent from Apple for $24 Million on January 3rd, 2018. The patent has a legal life of 20 years, but a the useful life of 10. Record the necessary entry as of January 3rd, 2018. Assume the patent was purchased using cash.          

Dr Patent 24,000,000

   Cr Cash 24,000,000

Adjusting entry:

January 31, 2018, patent amortization expense

Dr Patent amortization expense 200,000

   Cr Patent 200,000

9) Mason Automotive purchased $2 Million dollars worth of supplies on account on January 4, 2018.      

Dr Supplies 2,000,000

    Cr Cash 1,500,000

    Cr Accounts payable 500,000

Adjusting entry

January 31, 2018, supplies expense

Dr Supplies expense 500,000

   Cr Supplies 500,000    

10) Mason Automotive pre-pays for Rent Expense for the next year of $12 Million and Insurance Expense of $2.4 Million on January 4, 2018.  

Dr Prepaid rent 12,000,000

Dr Prepaid insurance 2,400,000

   Cr Cash 14,400,000

Adjusting entries:

January 31, 2019, rent expense

Dr Rent expense 1,000,000

   Cr Prepaid rent 1,000,000

January 31, 2019, insurance expense

Dr Insurance expense 200,000

   Cr Prepaid insurance 200,000        

11) On January 20th, Mason Automotive decides to purchase 2,000,000 shares of Treasury stock at $25 per share.

Dr Treasury stock 50,000,000

   Cr Cash 50,000,000

<h2><u>Closing journal entries:</u></h2>

Dr Sales revenue 90,000,000

    Cr Income summary 90,000,000

Dr Income summary 71,006,66.66

    Cr Wages expense 12,000,000

    Cr FICA taxes expense 840,000

    Cr interest expense 766,666.66

    Cr Depreciation expense 1,000,000

    Cr Cost of goods sold 52,000,000

    Cr Bad debt expense 2,500,000

    Cr Patent amortization expense 200,000

    Cr Supplies expense 500,000

    Cr Rent expense 1,000,000

    Cr Insurance expense 200,000

Dr Income summary 18,993,333.34

    Cr Retained earnings 18,993,333.34

8 0
3 years ago
Other questions:
  • Working capital cash flow. Cool​ Water, Inc. sells bottled water. The firm keeps in inventory plastic bottles at 11​% of the mon
    6·1 answer
  • A common set of accounting standards and procedures are called
    8·1 answer
  • The par value per share of common stock represents the
    11·1 answer
  • Why are websites operated by recognized print publishers, such as newspapers and journals, generally accurate and reliable?
    6·1 answer
  • Which of the following changes would bring the U.S. capital stock, currently below the Golden Rule level, closer to the steady-s
    8·1 answer
  • Vaida, a manager, sets up delivery schedules for the logistic team for the orders received online, as part of their new e-Commer
    6·2 answers
  • At Nanclet, a market research firm, whenever a particular team needs to hire people, the human resource (HR) department conducts
    12·1 answer
  • Two ships leave port at the same time, Ship X is heading due north and Ship Y is heading due east. Thirteen hours later they are
    8·2 answers
  • Conroy Company uses the allowance method to account for bad debts. During the year, Conroy determined that a balance of $200 fro
    7·1 answer
  • A loan processor who is not required to perform her duties at the direction of or subject to the supervision and instruction of
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!