Question

Homework Problem In chapter 3, we discussed Repaying a Debt, Plan #3: Constant Payment Using the same understanding, develo
Build Amortization Table . Borrow $4000 . N= 5 years i = 10% Equal annual payments ·A= Copyright Oxford University Press 2020
Output of Amortization Table 4000 Amount borrowed 5 N 10% i $1,055.19 payment Period Interest Principal 0 1 2 3 4 5 400.00 33
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Amortization Table 4,000 Amount Borowed 51N 10% i 1,055.19 Payment Period Interest Principal Balance Due 0 4,000.00 1 400.00

Add a comment
Know the answer?
Add Answer to:
Homework Problem In chapter 3, we discussed "Repaying a Debt, Plan #3: Constant Payment" Using the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Intermediate Accounting II Handout Homework Problem #4 On BONDS Payable for Chapter 14 Spring 2020 Due...

    Intermediate Accounting II Handout Homework Problem #4 On BONDS Payable for Chapter 14 Spring 2020 Due in class on Wednesday, February 12, 2020 On August 1, 2019. your company sold $150,000 of 8%, 10 year bonds when the market rate was 7%. These bonds pay interest annually on July 31 each year. Your company uses the interest method of amortization. Calculate the selling price of the bonds. Show the time value of money factors you entered into your calculator. Prepare...

  • 5 g Debts-2020 Spri.. Yahoo! 403 Forbidden REQUIRED: Homework Chapter 3 Homework Chapter 3 i Saved...

    5 g Debts-2020 Spri.. Yahoo! 403 Forbidden REQUIRED: Homework Chapter 3 Homework Chapter 3 i Saved Help Save & Exit Submit Consider the following situations for Shocker: a. On November 28, 2018, Shocker receives a $3,750 payment from a customer for services to be rendered evenly over the next three months. Deferred Revenue is credited. b. On December 1, 2018, the company pays a local radio station $2,550 for 30 radio ads that were to be aired, 10 per month,...

  • ents due annually, on March 1. Each payment consists of $20,000 principal plus one year's interest....

    ents due annually, on March 1. Each payment consists of $20,000 principal plus one year's interest. redit More Info 2018 Mar. 1 Borrowed $300,000 from Bartow Bank. The 15-year, 9% note requires payments due annually, on March 1. Each psyment consists of $20,000 principal plus one year's interest Dec. 1 Mortgaged the warehouse for $400,000 cash with Sammon Bank. The mortgage requires monthly payments of $6,000. The interest rate on the note is 6 % and accrues monthly. The first...

  • Problem 7-3 (LG 7-4) 10 You plan to purchase an $140,000 house using a 15-year mortgage...

    Problem 7-3 (LG 7-4) 10 You plan to purchase an $140,000 house using a 15-year mortgage obtained from your local bank. The mortgage rate offered to you is 5 percent. You will make a down payment of 10 percent of the purchase price. points Skipped a. Calculate your monthly payments on this mortgage. b. Calculate the amount of interest and, separately, principal paid in the 120th payment. c. Calculate the amount of interest and, separately, principal paid in the 150th...

  • Notes payable (due in 5 years) Accounts payable Bonds payable (due in 10 years) Machinery $...

    Notes payable (due in 5 years) Accounts payable Bonds payable (due in 10 years) Machinery $ 5,000 1,500 12,000 6,500 Discount on bonds payable Wages payable Interest payable (due in 2 weeks) Sales tax payable $1,400 700 350 300 Prepare the liabilities section of its classified balance sheet. (Negative amount(s) should be indicated by a minus sign.) WOOHOO CO. Liabilities Section of Balance Sheet December 31 Liabilities Current liabilities Total current liabilities Long-term liabilities Total long-term liabilities Total liabilities Exercise...

  • homework question an t 2012 Yeart ofte s Als require explanations Date AOOUD PR Dr. Or Explanation to include detai...

    homework question an t 2012 Yeart ofte s Als require explanations Date AOOUD PR Dr. Or Explanation to include details of the note) 100N Use this amortization table to do your journal entries: 1 12 Note Amount: 0,00 terest Rate A lt Interest Rate per Matbly payment 0700 of Monthly Payments: Payment per period S0501 yment terest Principal Balance 40000 JOO 695 0 90460 052 RL Il TS l 21 72720 YAR 18 ou the payoff of the related balances...

  • 1. In Cell D8 create formula PMT=PV/((1-1/(1+k)^n)/k), to calculate the periodic payment on a loan. 2....

    1. In Cell D8 create formula PMT=PV/((1-1/(1+k)^n)/k), to calculate the periodic payment on a loan. 2. In cell F8 use built-in function =PMT(k,n,PV). You should get identical answers. 3. Create amortization table (use absolute and relative addressing where appropriate). 4. Print worksheet. 5. Change loan amount and the rate (everything should adjust automatically) and print it again. 6. Print the cell formulas (force to one page). 7. Write report and explain all formulas and procedures. 8. Submit four printouts. PMT=$1589.99...

  • show all work please and explanations 3. You need to work on the mini-projects in Excel....

    show all work please and explanations 3. You need to work on the mini-projects in Excel. Your final mini-project report should be well- organized and typed in a Word file. Are required to submit both your Word report and Excel files to the instructor using the mini-project submission tool in Blackboard. The style and organization of the project accounts for 10 points. 4. You are required to work on the work independently. The due date for the project is 11:59pm...

  • newconnect.mheducation.com 10 Chap 6 Bad Debts - 2020 Spr. Yahoo! - 403 Forbidden REQUIRED: Homework Chapter...

    newconnect.mheducation.com 10 Chap 6 Bad Debts - 2020 Spr. Yahoo! - 403 Forbidden REQUIRED: Homework Chapter 3 Saved Help Save & Exit Homework Chapter 3 i Required information (The following information applies to the questions displayed below.) The December 31, 2018, adjusted trial balance for Fightin' Blue Hens Corporation is presented below. Credit Debit 11,600 146,000 5.600 28,000 360,000 Accounts Cash Accounts Receivable Prepaid Rent Supplies Equipment Accumulated Depreciation Accounts Payable Salaries Payable Interest Payable Notes Payable (due in two...

  • Problem 10-1A Straight-Line: Amortization of bond discount LO P2 Topic: Click here to ask chapturstplated queste...

    Problem 10-1A Straight-Line: Amortization of bond discount LO P2 Topic: Click here to ask chapturstplated queste Ch 10: Homework Ch 10: Homework Saved Help Save & Exit Submit Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion Return to question Required: 1. Prepare the January 1 journal entry to record the bonds' issuance. 2(a) For each semiannual period, complete the table below to calculate the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT