Make a table of computation for this if the given is:Amount Borrowed: 76,779.00 Periods: 60 months Rate is 0.1Payment: 1,282.91Zoom in the excel or the table and make sure it is readable Amount borrowedP90,799.74PeriodsP36.00RateP0.01PaymentP2,960.21MonthPmtEnding BalanceP88,649.91FreebiesBeginningInterestPrincipalDown PaymentMotorcycle Cover1P90,799.74P2,960.21P810.39P2,149.8217,180P88,649.91P86,480.90P2,960.21P2,960.21Warranty2P791.20P2,169.01P86,480.90Helmet3P771.84P2,188.37P84,292.53P84,292.53P82,084.63P2,960.21P2,960.21Yamaha stickers4P752.31P2,207.90P82,084.635P732.61P2,227.61P79,857.02P79,857.02P77,609.536P2,960.21P712.72P2,247.49P77,609.537P2,960.21P692.67P2,267.55P75,341.98P75,341.98P73,054.20P2,960.21P2,960.218P672.43P2,287.79P73,054.20P652.01P2,308.20P70,745.99P70,745.99P68,417.19P2,960.21P2,960.2110P631.41P2,328.80P68,417.1911P610.62P2,349.59P66,067.60P66,067.60P63,697.04P2,960.21P2,960.2112P589.65P2,370.56P63,697.0413P568.50P2,391.72P61,305.32P61,305.32P58,892.26P2,960.21P2,960.2114P547.15P2,413.06P58,892.2615P525.61P2,434.60P56,457.66P56,457.66P54,001.34P2,960.21P2,960.2116P503.88P2,456.33P54,001.3417P481.96P2,478.25P51,523.08P51,523.08P49,022.72P2,960.21P2,960.2118P459.84P2,500.37P49,022.7219P437.53P2,522.68P46,500.03P46,500.03P43,954.83P2,960.21P2,960.21P2,545.20P2,567.9220P415.01P43,954.8321P392.30P41,386.92P41,386.92P38,796.08P2,960.21P2,960.2122P369.38P2,590.83P38,796.0823P346.26P2,613.96P36,182.12P36,182.12P33,544.84P2,960.21P2,960.2124P322.93P2,637.29P33,544.8425P299.39P2,660.82P30,884.01P30,884.01P28,199.44P2,960.21P2,960.2126P275.64P2,684.57P28,199.4427P251.68P2,708.53P25,490.91P25,490.91P22,758.20P2,960.21P2,960.2128P227.51P2,732.71P22,758.2029P203.12P2,757.10P20,001.10P20,001.10P17,219.40P2,960.21P2,960.2130P178.51P2,781.70P17,219.4031P153.68P2,806.53P14,412.87P14,412.87P11,581.29P2,960.21P2,831.58P2,856.8532P128.63P11,581.29P2,960.21P2,960.21P2,960.2133P103.36P8,724.45ActP8,724.45P5,842.1034P77.87P2,882.35P5,842.1035P52.14P2,908.07P2,934.03Go t36P2,934.03P2,960.21P26.19P2,934.03P0.00P90,799.74

Here the question is asking for the preparation of the amortization schedule for the loan. The…

Answered: Make a table of computation for this if…

Make a table of computation for this if the given is: Amount Borrowed: 76,779.00 Periods: 60 months Rate is 0.1 Payment: 1,282.91 Zoom in the excel or the table and make sure it is readable

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter6: Investing And Financing Activities

Section: Chapter Questions

Problem 3.5C

See similar textbooks

Related questions

Q: Assume that you start with a balance of $3900 on your credit card. During the first month you charge…

A: A credit card is a card that is issued by the bank to the users to enable that holder to pay a…

Q: Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days…

A: We need to use previous balance method to calculate monthly finance charge. Finance Charge using…

Q: Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days…

A: The daily balance method totals your finance charges for each day of the month. To do this…

Q: Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days…

A: Formula to calculate the charge using the average daily balance method is: (Balance*10) +…

Q: Amortization schedule must include Interest calculation and a running balance

A: An amortization schedule is to be created for the given data. Amortization of loan has equal monthly…

Q: Assume that you start with a balance of $3900 on your credit card.During the first month you charge…

A: Here, Balance on Credit Card is $3900 APR is 29% Charges for first Month is $400 Charges for Second…

Q: You have taken a loan of $6,000.00 for 3 years at 1.8% compounded monthly. Fill in the table below:…

A: Loan amount = $6,000 Time Period = 3 years Compounded Monthly rate = 1.8%

Q: Develop a general-purpose spreadsheet to calculate the balance due, principal payment, and interest…

A: workings:

Q: Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days…

A: The adjusted balance method is indeed an accounting technique that calculates finance charges on the…

Q: Complete the following take table. Round your answer to the nearest cent. Table 1 month- Previous…

A: Month 1: Outstanding balance in beginning = 610$ APR = 24% Finance charge = 610$ * 24% * 1/12 =…

Q: Calculate the monthly finance charge for the credit card transaction. It takes 10 days for a payment…

A: We will calculate the interest on the basis of simple interest.

Q: Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days…

A: The question is based on the calculation of financial charges on a credit card. The Financial…

Q: a. A Visa credit card issued through Frost Bank carries an interest rate of 1% per month on the…

A: Effective Annual Rate is a modified rate of return where it considers the compounding effect.…

Q: Use the PMT function in Excel to compute the monthly payment on a $351000 business loan at an annual…

A: given that, loan amount = $351000 annual interest = 4.46% number of payments = 30 years * 12 = 360…

Q: Part 1 a. Calculate P1+r12n and call this number A. A=enter your response here (Round to two…

A: Time value of money (TVM) is used to measure the value of money at different point of time in the…

Q: You have taken a loan of $5,000.00 for 4 years at 3.6% compounded monthly. Fill in the table below:…

A: Given: Particulars Amount Loan 5000 Years 4 Interest rate 3.60%

Q: Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days…

A: Given information : Time it takes for payment = 10 days Length of month = 30 days Balance = $475…

Q: a) Calculate the amount of new purchases made this month. b) What is your new balance? c) The…

A: The attached image is a Credit card Statement. Every month, the statement is shared to the account…

Q: A credit card has a 21.99% APR, a minimum monthly payment of 3.15%, and a current monthly statement…

A: A credit card is a pay later facility provided by the banks to its customers. Banks charge interest…

Q: Find i (the rate per period) and n (the number of periods) for the following loan at the given…

A: Given Information Semi-Annual Payments = $4800 Time Period = 17 years Interest rate = 7.45%…

Q: Borrowed $5,000 at a simple interest rate of 10% p.a. and charged interest of $600. What is the time…

A: Principal Amount(P) =$5000 Interest rate(r) = 10% Interest Amount(I) = $600 Time Period =t As per…

Q: You have an account with a $1000 credit limit that charges 12.25% interest using the average daily…

A: In credit cards they are charged based on the daily balance and there is need of daily balance and…

Q: e the following information from an account analysis statement to answer the following questions: •…

A: The practice of ensuring that consumers pay their bills on time is known as accounts receivable…

Q: The simple interest charged on an 8-month loan of $95,000 is $974. Find the simple interest rate.…

A: Simple interest = Amount*Rate*time in years

Q: Amount Rate Time $63,000 12% 3 years table of monthly payments on a $1,000…

A: Loan amount (PV) = $ 63000 Annual interest rate = 12% Monthly interest rate (R) = 12%/12 = 1%…

Q: An account paying annual compound interest was opened with OMR2,000 10 years ago. Today, the account…

A: The calculation is: Values in OMR.

Q: Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days…

A: Finance charge refers to the amount that is billed to the card account if the previous month’s total…

Q: The simple interest charged on a 11-month loan of $54,000 is $732. Find the simple interest rate.…

A: simple interest can be given by the formula: I=P×R×T100

Q: Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days…

A: Information Provided: Balance = $600 Rate = 18% Payment = $550 Term = 10/30 days

Q: You have taken a loan of $5,000.00 for 4 years at 2.9% compounded monthly. Fill in the table below:…

A: The monthly payment is the payment that is paid every month until the loan amortized which includes…

Q: calculate the monthly finance charge for the credit card transaction. Know that it takes 10 days for…

A: There are various method in which the interest on credit card is charges such as previous balance,…

Q: The balance on a credit card, that charges a 20% APR interest rate, over a 1 month period is given…

A: Average daily balance is the average of the monthly expenses Date No of days Balance…

Q: Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days…

A: Average Daily method: in this method for a billing cycle Each day Balance is Divided by the Total…

Q: Find the amount owed on an investment of $10,000 into a money market account that pays a simple…

A: Principal amount=$10000 Interest rate =1.75% Period of time=39 weeks i.e. 0.75 year* *52 weeks=1…

Q: You have taken out a loan of $11,000.00 for 4 years at an APR of 4.6% (loans are always compounded…

A: P=principal r= interest rate n=number of payments

Q: You have taken a loan of $6,000.00 for 3 years at 2.9% compounded monthly. Fill in the table below:…

A: Loan Amount = $6000 Year = 3 years Compunded monthly = 2.9% CI = P(1 + (r/12) )12t - P where, P…

Q: The balance on a credit card, that charges a 20% APR interest rate, over a 1 month period is given…

A: Credit card is a facility provided by the credit card companies to its customers in which customer…

Q: Consider a loan of $7000 with an APR of 9% and a loan term of 10 years. Complete parts (a) through…

A: Loan is $7000 APR is 9% Loan term is 10 years. Monthly payment is $88.67 To Verify: Balance at…

Q: Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days…

A: Given information: Balance amount $3,000 Periodic rate is 17% Payment is $2,500

Q: The table below shows the expenses and payments for 8 months on a credit card account with an…

A: Credit card Balance Formula: Balance = Previous balance - Payment + expense + interest Interest =…

Q: Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days…

A: Case : As the question provides that the payment receive and record would take time of 10 days .…

Q: The balance on a credit card, that charges a 12% APR interest rate, over a 1 month period is given…

A: A credit card refers to a facility provided by banks to its customers that customers can make the…

Q: 1. What balance will be in an account at the end of 10 years, if € 3 500 is deposited today and…

A: Future value refers to the value of an asset on a specified date in the future. It can be calculated…

Q: Find the monthly payment and estimate the remaining balance. Assume interest is on the upaid…

A: The question is based on the concept of Annuity in Financial Management. Annuity refers to the…

Q: Make a table of computation for this if the given is: Amount Borrowed: 76,779.00 Periods: 60…

A: Amount Borrowed: 76,779.00 Periods: 60 months Rate is 10% Payment: 1,282.91 With Monthly Payment…

Q: Don't know how to solve

A: Ending balance after 3rd month = $2103.29 Monthly payment (M) = $150 Interest rate (r) = 0.75% per…

Q: 1. Loan Amount 2. monthly payment on a 30 year loan (use pmt) 3. total interest paid over the life…

A: A loan is a sort of debt that is taken on by an individual or another institution. The lender, which…

Question

Make a table of computation for this if the given is:

Amount Borrowed: 76,779.00

Periods: 60 months

Rate is 0.1

Payment: 1,282.91

Zoom in the excel or the table and make sure it is readable

Amount borrowed
P90,799.74
Periods
P36.00
Rate
P0.01
Payment
P2,960.21
Month
Pmt
Ending Balance
P88,649.91
Freebies
Beginning
Interest
Principal
Down Payment
Motorcycle Cover
1
P90,799.74
P2,960.21
P810.39
P2,149.82
17,180
P88,649.91
P86,480.90
P2,960.21
P2,960.21
Warranty
2
P791.20
P2,169.01
P86,480.90
Helmet
3
P771.84
P2,188.37
P84,292.53
P84,292.53
P82,084.63
P2,960.21
P2,960.21
Yamaha stickers
4
P752.31
P2,207.90
P82,084.63
5
P732.61
P2,227.61
P79,857.02
P79,857.02
P77,609.53
6
P2,960.21
P712.72
P2,247.49
P77,609.53
7
P2,960.21
P692.67
P2,267.55
P75,341.98
P75,341.98
P73,054.20
P2,960.21
P2,960.21
8
P672.43
P2,287.79
P73,054.20
P652.01
P2,308.20
P70,745.99
P70,745.99
P68,417.19
P2,960.21
P2,960.21
10
P631.41
P2,328.80
P68,417.19
11
P610.62
P2,349.59
P66,067.60
P66,067.60
P63,697.04
P2,960.21
P2,960.21
12
P589.65
P2,370.56
P63,697.04
13
P568.50
P2,391.72
P61,305.32
P61,305.32
P58,892.26
P2,960.21
P2,960.21
14
P547.15
P2,413.06
P58,892.26
15
P525.61
P2,434.60
P56,457.66
P56,457.66
P54,001.34
P2,960.21
P2,960.21
16
P503.88
P2,456.33
P54,001.34
17
P481.96
P2,478.25
P51,523.08
P51,523.08
P49,022.72
P2,960.21
P2,960.21
18
P459.84
P2,500.37
P49,022.72
19
P437.53
P2,522.68
P46,500.03
P46,500.03
P43,954.83
P2,960.21
P2,960.21
P2,545.20
P2,567.92
20
P415.01
P43,954.83
21
P392.30
P41,386.92
P41,386.92
P38,796.08
P2,960.21
P2,960.21
22
P369.38
P2,590.83
P38,796.08
23
P346.26
P2,613.96
P36,182.12
P36,182.12
P33,544.84
P2,960.21
P2,960.21
24
P322.93
P2,637.29
P33,544.84
25
P299.39
P2,660.82
P30,884.01
P30,884.01
P28,199.44
P2,960.21
P2,960.21
26
P275.64
P2,684.57
P28,199.44
27
P251.68
P2,708.53
P25,490.91
P25,490.91
P22,758.20
P2,960.21
P2,960.21
28
P227.51
P2,732.71
P22,758.20
29
P203.12
P2,757.10
P20,001.10
P20,001.10
P17,219.40
P2,960.21
P2,960.21
30
P178.51
P2,781.70
P17,219.40
31
P153.68
P2,806.53
P14,412.87
P14,412.87
P11,581.29
P2,960.21
P2,831.58
P2,856.85
32
P128.63
P11,581.29
P2,960.21
P2,960.21
P2,960.21
33
P103.36
P8,724.45
Act
P8,724.45
P5,842.10
34
P77.87
P2,882.35
P5,842.10
35
P52.14
P2,908.07
P2,934.03
Go t
36
P2,934.03
P2,960.21
P26.19
P2,934.03
P0.00
P90,799.74

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

ThefollowingtrialbalancehasbeenextractedfromtheledgerofMr.Cole,asoletrader:Trialbalanceasat31December,2020ParticularsDebit¢Credit¢Sales138,000Purchases82,350Travelexpenses5,200Drawings7,800Rent,rates&insurance6,600Postageandstationery3,000Advertisement1,330Salariesandwages26,420Baddebt8,700InvestmentIncome15,890Debtors12,120 Creditors 130 Cashinhand1,700Cashatbank1,000Inventoryasat1January,202011,800Equipmentatcost58,000Loan19,000Capital53,000226,020226,020Inventoryatthecloseofbusinesshasbeenvaluedat¢13,500Required;Prepareanincomestatementfortheyearending31stDecember2020andabalancesheetasatthatdate.
CODE AND NAME OF THE ACCOUNT WILL RECEIVE DEBT 100 01 TL Case 23000 100 02 Dollars Case 23000B) CODE AND NAME OF THE ACCOUNT WILL RECEIVE DEBT 102 02 X Bank DTH Hes 23000 100 01 TL Case 23000C) CODE AND NAME OF THE ACCOUNT WILL RECEIVE DEBT 100 02 Dollars Case 23000 100 01 TL Case 23000D) THE CODE AND NAME OF THE ACCOUNT WILL RECEIVE DEBT 100 03 Case of Euro 5000 100 01 TL Case 5000E) CODE AND NAME OF THE ACCOUNT WILL RECEIVE DEBT 100 02 Dollars Case 5000 100 01 TL Case 5000
P = $809,100; R= 7.09%; n= 360 . Calculate monthly payment
ACC 122 Fall 2020Comprehensive ProjectBestValue Corporation's Trial Balance at December 31, 20XX is presented below.All 20XX transactions have been recorded except for the items described on the next page.Debit CreditCash $ 109,890Accounts Receivable 28,789Inventory 25,540Debt Investments 0Land 55,674Buildings 215,850Equipment 75,120Allowance for Doubtful Accounts $ 1,027Accumulated Depreciation-Buildings 63,306Accumulated Depreciation-Equipment 16,048Accounts Payable 35,278Interest Payable 0Unearned Rent Revenue 48,900Dividends Payable 0Income Tax Payable 0Bonds Payable 0Discount on Bonds Payable 0Common Stock ($2 par) 29,200Paid in Capital in Excess of Par-Common Stock 44,580Preferred Stock ($60 par) 0Paid in Capital in Excess of Par-Preferred Stock 0Retained Earnings 107,904Treasury Stock 0Cash Dividends 0Sales Revenue 776,068Rent Revenue 0Gain on Sale of Land 0Bad Debt Expense 0Interest Expense 0Cost of Goods Sold 478,542Depreciation Expense 0Other Operating Expenses 53,274Salaries…
8. The ownerwithdrawscash forpersonalused.9. Thecompanypurchasesland by paying halfin cash andsigning anote.10. Thecompanypays thesupplier fortheirpurchaseslast month.
which one is correct please confirm? Q7: If GBP/USD 1.4462/67 and USD/CHF 1.6688/93, what is the GBP/CHF rate?" GBP/CHF 2.4134/2.4150 CHF/GBP 2.4134/2.4150 CHF/GBP 2.7138/2.7173 GBP/CHF 2.7138/2.7173
Amount financed 18200 number of payments 72 monthly payment 425.08 finace charge 12405.76 whats the apr%
6 - Which of the following is the account and amount that should appear in the dotted places in the journal article above? a) 191 VAT Deductible 5.400 TL B) 391 VAT to be calculated Hs. 5.400 TL NS) 391 Calculated VAT Hs. 6.300 TL D) 360 Taxes and Funds Payable Hs. 5.400 TL TO) 191 VAT Deductible 5,000 TL
What is the vat payable? P43,830 P44,280 P46,680 P59,248
If the cash is 135, marketable securities 120, bills payable 35, bills receivable 45, outstanding expenses 20, creditors 110, debtors 50, the contingency rate is 0.131, then what is net working capital required? Select one: a. 209.24 b. 158.34 c. All the given choices are not correct d. 152.69 e. 231.85
An invoice in the amount of $200 carries cashterms of “2/10, net 30.” If the buyer takesadvantage of the discount terms, how much willthe buyer pay?a. $100b. $120c. $140d. $160e. $196
Please provide journal entries for the below situation, including payment of bill. 01/01/2022 Security Deposit for Utilities Bill Paid : $39030/01/2023 Partial Refund of Deposit : $160 Utilities Bill for January 2023 dated 30/01/23Electricity Charges : $143.22Less: Deposit Refund : -$160Sub-total : -$5.31Tax @ 8% : $11.46Total Amount Payable: $6.15