HW 1.2 Analytic Representations_Equations-Maria Huerta
pdf
keyboard_arrow_up
School
Tidewater Community College *
*We aren’t endorsed by this school
Course
154
Subject
Accounting
Date
Apr 3, 2024
Type
Pages
2
Uploaded by ProfResolveKouprey29
1/17/24, 2:12 PM
HW 1.2 Analytic Representations/Equations-Maria Huerta
https://tdx.acs.pearsonprd.tech/api/v1/print/highered
1/2
Student: Maria Huerta
Date: 01/17/24
Instructor: Dania Sinibaldi
Course: Quantitative Reasoning O06B SP24
Assignment: HW 1.2 Analytic
Representations/Equations
Consider a home mortgage of $
at a fixed APR of % for years.
75,000
7.5
20
a. Calculate the monthly payment.
b. Determine the total amount paid over the term of the loan.
c. Of the total amount paid, what percentage is paid toward the principal and what percentage is paid for interest?
a. The monthly payment, PMT, required to repay a loan of P dollars paid n times per year over Y years at an annual rate APR is given by the following formula.
PMT =
P
APR
n
1 −
1 +
APR
n
− nY
To use the formula to determine the monthly payment, PMT, first identify the values for P, APR, n, and Y. The value of P is $
.
75,000
The value of APR, as a decimal, is .
0.075
The value of n is .
12
The value of Y is years.
20
Now substitute the values of P, APR, n, and Y in the formula.
PMT =
P
APR
n
1 −
1 +
APR
n
− nY
=
$75,000
0.075
12
1 −
1 +
0.075
12
− 12(20)
Simplify the numerator.
PMT =
$75,000
0.075
12
1 −
1 +
0.075
12
− 12(20)
=
$468.75
1 −
1 +
0.075
12
− 12(20)
Next simplify the denominator.
PMT =
$468.75
1 −
1 +
0.075
12
− 12(20)
=
$468.75
0.77582582
Finally divide.
PMT =
$468.75
0.77582582
= $604.19
1/17/24, 2:12 PM
HW 1.2 Analytic Representations/Equations-Maria Huerta
https://tdx.acs.pearsonprd.tech/api/v1/print/highered
2/2
The monthly payment is $
.
604.19
b. To find the total amount paid over the term of the loan, multiply the monthly payment by the number of months in years. Since there are 12 months in a year, the monthly payment is paid (12)(
)
times.
20
20 = 240
Calculate the total amount paid over the term of the loan.
$
(
)
$
604.19 240 =
145,005.60
The total amount paid over the term of the loan is $
.
145,005.60
c. The entire starting loan principal must be repaid over the term of the loan. The amount of the total payment over the term of the loan that goes to principal is P, $75,000.
To find the percentage of the total amount paid that goes toward the principal, divide P by total amount paid and multiply by 100, rounding to one decimal place. %
100
$75,000
$145,005.60
51.7
The amount of interest paid is the difference between the total payment and the total amount borrowed.
$
$
$
145,005.60 −
75,000 =
70,005.60
To calculate the percent paid for interest, divide the amount paid for interest by the total amount paid and multiply by 100, rounding to one decimal place.
%
100
$70,005.60
$145,005.60
48.3
Therefore, the total amount paid over the length of the loan, % is paid toward the principal and % is paid for interest.
51.7
48.3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
X +
A https://player-ui.mheducation.com/#/epub/sn_7cac#epubcfi(%2F6%2F326%5Bdata-uuid-ab153a0624d544c282287e02
5. Calculating Monthly Mortgage Payments. Based on U Exhibit 9-9, or using a financial calculator, what
would be the monthly mortgage payments for each of the following situations?
a. $120,000, 15-year loan at 4.5 percent.
b. $86,000, 30-year loan at 5 percent.
c. $105,000, 20-year loan at 6 percent.
d. What relationship exists between the length of the loan and the monthly payment? How does the
mortgage rate affect the monthly payment?
arrow_forward
Courses
Mastering Chernie X
2MateryCheme X
loud/modules/unproctoredTest.QuestionSheet
McCraith-Sectic x
Updte
Help Caroline Achienge S01243611acadceduLogout
all 2021 I Chapter 1 Consumer Finance / Section 1.5 Digital Exercises
Gradebook.
Extemat
kercises
Remaining Time Unimted
Suppose you are paid $3,000 per month and your employer's 401(k) matches your contributions by 10% up to a
maximum of 15% of your pay. Assuming you max-out your retirement savings and you work for 25 years, how
much will the 401(k) be worth when you retire (if you can get an APR of 8% during your work years)? If you are
taxed at a rate of 27%, then how much will you have when you retire?
Round all answers to 2 decimal places.
Before taxes retirement amount $
Number
After taxes retirement amount $
Number
Submit Assignment
Quit & Save
Васк
Question Menu 4
Next
38°F Partly sunny A 0)
411 PM
11/19/202
end
home
delete
prt sc
144
4+
4-
40
num
lock
backspace
&
8.
6.
7.
home
|近
arrow_forward
Question 1 parts a-d
arrow_forward
Come
* CengageNOowv2 | Online teach x
Update
akeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator%3&inprogress%-false
Amortize Premium by Interest Method
Shunda Corporation wholesales parts to appliance manufacturers. On January 1, Shunda issued $30,000,000 of five-year, 10% bonds at a market (effective) interest rate
of 8%, receiving cash of $32,433,150. Interest is payable semiannually. Shunda's fiscal year begins on January 1. The company uses the Interest method.
a. Journalize the entries to record the following:
1. Sale of the bonds. Round to the nearest dollar. If an armount box does not require an entry, leave it blank.
the nearest dollar. If an amount box does not require an entry, leave it blank.
2. First semiannual interest payment, including amortization of premium. Round
3. Second semiannual interest payment, including amortization of premium. Round to the nearest dollar. If an amount box does not require an entry, leave it blank.
b. Determine the bond…
arrow_forward
Home
* CengageNOW x
O Wayne Comm X
w Course: 2021S x Course: 20215 x4 Chp 2 - Googl x+
w.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=...
☆ た
eBook
Show Me How
Transactions
Innovative Consulting Co. has the following accounts in its ledger: Cash, Accounts Receivable, Supplies, Office Equipment, Accounts Payable, Common
Stock, Retained Earnings, Dividends, Fees Earned, Rent Expense, Advertising Expense, Utilities Expense, Miscellaneous Expense.
Journalize the following selected transactions for October 20Y2 in a two-column journal. Journal entry explanations may be omitted. If an amount box
does not require an entry, leave it blank.
Oct. 1. Paid rent for the month, $2,500.
4. Paid advertising expense, $1,000.
5. Paid cash for supplies, $1,800.
6. Purchased office equipment on account, $11,500.
12. Received cash from customers on account, $7,500.
20. Paid creditor on account, $2,700.
27. Paid cash for miscellaneous expenses, $700.
30.…
arrow_forward
Eat
min
C
e
New tab
Λ Content
xW Quiz 3-MAT-143, section 03F, Fa X
+
Q
A ✩
https://www.webassign.net/web/Student/Assignment-Responses/last?dep=34832472
Viewing Saved Work Revert to Last Response
DETAILS
MY NOTES
You deposit $850 in an account paying an annual simple interest rate of 7.8%. Find the future value of the investment (in dollars) after 1 year.
DETAILS
MY NOTES
Calculate the simple interest due (in dollars) on a 40-day loan of $1,600 if the annual interest rate is 9%. (Use 360 days in 1 year.)
$
DETAILS
MY NOTES
arrow_forward
None
arrow_forward
My question is How do I find the formula for Cell A11 and where do I need to calculate those so that I can work on that easily before putting in Excel?
arrow_forward
Match the words with the term.
Question 13 options:
12345
mortgage
12345
trade receivables
12345
equipment
12345
working capital
12345
inventory
1.
factoring
2.
warehouse financing
3.
line of credit
4.
term loan
5.
building
arrow_forward
What is the right answer from A to D? Please help me
arrow_forward
Odysseyware
LEARN
MESSAGE
HELP
SIGN OUT
ASSIGNMENTS
COURSES
Assignment -3. Automobile Loans
Attempt 1 of 1
SECTION 4 OF 4
QUESTION 6 OF 6
1
2
3
4
>>
Mark takes out a loan for $20,000. The loan has 2% interest rate and a 2.5% APR. Complete the following statement.
The sum of the interest plus fees on this loan is
$900
$500
$600
400
TURN IT IN
O ASK FOR HELP
1124 PM
SUBMIT ANSWER
40ENG
2/6/2021
P Type here to search
Delete
144
BackncRce
&
%
#3
8
7
2
3
4
P
Y
U
arrow_forward
OW21 Onlin teachin x
N2 | Online teaching
esource from Cengag...
w.com
eBook
Cash
Inventory
Land
Notes Payable
tMain.do?invoker=&takeAssignmentSession Locator=&inprogress=false
V
Xi Lin, Capital
Feedback
ps
Panthère de Cartier...
✓
Show Me How
Journalizing Partner's Original Investment
assumed a $57,000 note payable owed by Lin that was used originally to purchase the land.
Xi Lin contributed land, inventory, and $35,000 cash to a partnership. The land had a book value of $79,000 and a market value of $152,000. The inventory had a book value of $53,100 and a market value of $48,900. The partnership also
Required:
Provide the journal entry for Lin's contribution to the partnership. If an amount box does not require an entry, leave it blank.
35,000
53,100 X
152,000
48,900
X
79,000 X
57,000
Pink Playful Femini...
Check My Work 5 more Check My Work uses remaining.
&
MX
Check My Work
Record the assets at their current values, and record the liability at its current value. Lin's Capital…
arrow_forward
I need answer typing
arrow_forward
I need help with the questions, provide the steps and find the right work in the Excel spreadsheet.
arrow_forward
Need help
arrow_forward
23
eBook
Print
References
Determine the amount of the Earned Income Credit in each of the following cases. Assume that the person or persons are eligible to
take the credit. Use Table 9-3.
Required:
Calculate the credit using the formulas.
Note: For all requirements, do not round intermediate calculations. Round your final answers to the nearest whole dollar amount.
a. A single person with earned income of $8,720 and no qualifying children.
Earned Income
Credit
$
667
b. A single person with earned income of $24,200 and two qualifying children.
$
6,195
c. A married couple filing jointly with earned income of $36,060 and one qualifying child.
$
2,849
arrow_forward
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Tell me
Arial
10
A A°
Wrap Text v
General
A
$ v % 9
Paste
В
U
Merge & Center v
13
fx
A
В
C
E
F
J
1
2 Name: KhanGhulam IIII II ||
3 Amortization Schedule
4 Instruction: Develop and amortization table for the payment of a loan on a house.
Payments are monthly for 10 years.
Loan on the house is $179,000.
5
6.
PMT formula
7
Interest is 5.3% annual.
8
PV formula
9
Payment:
10
11
Payment Payment
Number
Month
|Рayment
Amount
Beginning
Ending
Toward
Toward
12
Balance
Balance
Principal
Interest
Apr-02
May-02
13
1
179,000.00
14
15
3
16
4
17
18
19
7
20
8
21
9.
22
10
23
11
24
12
25
13
26
14
27
15
28
16
29
17
30
18
31
19
32
20
lili
arrow_forward
c
arrow_forward
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
Editing
Arial
V 10
Merge
Currency
...
B8
fx
A
1.
Amortization schedule
2.
3.
Loan amount to be repaid (PV)
$30,000.00
Interest rate (r)
4.
Length of loan (in years)
8.00%
6.
7.
a. Setting up amortization table
Formula
8.
Calculation of loan payment
#N/A
6.
Repayment of
Principal
10
Year
Beginning Balance
Payment
Interest
Remaining Balance
11
1
12
13
3
14
15 b. Calculating % of Payment Representing Interest and Principal for Each Year
Payment %
Representing
Payment %
Representing
Principal
Check: Total =
16
Year
Interest
100%
17
1
18
19
20
21
Formulas
= A Sheet1
Calculation Mode: Automatic
Workbook Statistics
LL
2 3
arrow_forward
Exploring Annuities with Microsoft Excel
I. Objectives:
To organize data and perform calculations using Microsoft Excel
To find future values for an annuity
To determine payment amounts for an annuity given a set goal
To analyze the effect of time
To research reasonable annuity rates and investment amounts for use in the above calculations
II. Procedure:
Sheet 1 - Future Value
1. Open a new Microsoft Excel (or Google Sheets) blank spreadsheet.
2. At the bottom of the page, it will show "Sheet 1". You can rename it "Future Value".
a. Right click the "Sheet 1" tab and you will see an option to rename it.
3. Type "Payment Amount (P)" in cell A1.
4. Type "Rate (i)" in cell B1.
5. Type "Number of Payments per year (n)" in cell C1.
6. Type "Years (t)" in cell D1.
Now the research..
You need to investigate reasonable annuity rates for our current market. You can choose a rate of your own
using the information you find. Also, I want you to find out what investors suggest your payment amount…
arrow_forward
Check Progress
QUESTION
FINANCING AND SETTLEMENT » FINANCING LEGISLATION
32 c
When a buyer goes in to apply for a loan on a new first mortgage, what must the lender give to the buyer?
Glossary Terms
Mortgage,
ANSWERS
EXPLANATION
A > The broker's commission amount
B > An estimate of the buyer's closing costs
C> An estimate of the seller's closing costs
D> A three day right of rescission document on the buyer's loan
CONN ESTW ITL CI
SCEPTR
arrow_forward
A v2.cengagenow.com
da EXCHANGE PASSWORD REQUIRED
1 FA2021 - Fina...
X CengageNOWv2 | Online teaching and learning reso.
11m
O https://www.toolingu.com/Ims/contentplayer/?corpo.
Enter your password for "hjmolin" in Internet
Accounts.
еВook
Show Me How
Note Payable and Accrued Interest
Fairborne Company borrowed $600,000 on an 8%, interest-bearing note on October 1, 2023. Fairborne ends its fiscal year on December 31. The note was paid with
interest on May 1, 2024.
Required:
1. Prepare the entry for this note on October 1, 2023. If an amount box does not require an entry, leave it blank.
2023 Oct. 1 Cash
Notes Payable
(Record issuance of note)
Feedback
2. Prepare the adjusting entry for this note on December 31, 2023. If an amount box does not require an entry, leave it blank.
2023 Dec. 31 Interest Expense
Interest Payable
(Record accrued interest)
Feedback
3. Indicate how the note and the accrued interest would appear in the balance sheet at December 31, 2023.
Among the current…
arrow_forward
MP
MT
HS
DS
CD
Simp
Conj
Add
DM
Com
Assoc
Dist
DN
Trans
Impl
Equiv
Exp
Taut
ACP
CP
AIP
IP
PREMISE
1.
H (~T ɔ R)
PREMISE
Hv (E ɔ F)
PREMISE
TVE
CONCLUSION
RVF
PREMISE
H D
FREMISE
RULE
-H
4 Simp
PREMISE
6. An investor lends $5000 and receives a
promissory note promising repayment of the
loan in 90 days with 8.5% simple interest. This
note is immediately sold to a bank that charges
8% simple interest. How much does the bank pay
for the note? What is the investor's profit? What
is the bank's profit on this investment when the
note matures?
2.
arrow_forward
A Final Exam - MATH 1330 - Math
b Details | bartleby
E New tab
A https://www.webassign.net/web/Student/Assignment-Responses/submit?dep=254878928tags=autosave#question4023958_1
Sign in
12.
DETAILS
HARMATHAP12 6.2.009.
MYΝΟΤΕS
What are the future value and the interest earned if $4000 is invested for 3 years at 8% compounded quarterly? (Round your answers to the nearest cent.)
future value
24
interest earned
%24
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- X + A https://player-ui.mheducation.com/#/epub/sn_7cac#epubcfi(%2F6%2F326%5Bdata-uuid-ab153a0624d544c282287e02 5. Calculating Monthly Mortgage Payments. Based on U Exhibit 9-9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? a. $120,000, 15-year loan at 4.5 percent. b. $86,000, 30-year loan at 5 percent. c. $105,000, 20-year loan at 6 percent. d. What relationship exists between the length of the loan and the monthly payment? How does the mortgage rate affect the monthly payment?arrow_forwardCourses Mastering Chernie X 2MateryCheme X loud/modules/unproctoredTest.QuestionSheet McCraith-Sectic x Updte Help Caroline Achienge S01243611acadceduLogout all 2021 I Chapter 1 Consumer Finance / Section 1.5 Digital Exercises Gradebook. Extemat kercises Remaining Time Unimted Suppose you are paid $3,000 per month and your employer's 401(k) matches your contributions by 10% up to a maximum of 15% of your pay. Assuming you max-out your retirement savings and you work for 25 years, how much will the 401(k) be worth when you retire (if you can get an APR of 8% during your work years)? If you are taxed at a rate of 27%, then how much will you have when you retire? Round all answers to 2 decimal places. Before taxes retirement amount $ Number After taxes retirement amount $ Number Submit Assignment Quit & Save Васк Question Menu 4 Next 38°F Partly sunny A 0) 411 PM 11/19/202 end home delete prt sc 144 4+ 4- 40 num lock backspace & 8. 6. 7. home |近arrow_forwardQuestion 1 parts a-darrow_forward
- Come * CengageNOowv2 | Online teach x Update akeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator%3&inprogress%-false Amortize Premium by Interest Method Shunda Corporation wholesales parts to appliance manufacturers. On January 1, Shunda issued $30,000,000 of five-year, 10% bonds at a market (effective) interest rate of 8%, receiving cash of $32,433,150. Interest is payable semiannually. Shunda's fiscal year begins on January 1. The company uses the Interest method. a. Journalize the entries to record the following: 1. Sale of the bonds. Round to the nearest dollar. If an armount box does not require an entry, leave it blank. the nearest dollar. If an amount box does not require an entry, leave it blank. 2. First semiannual interest payment, including amortization of premium. Round 3. Second semiannual interest payment, including amortization of premium. Round to the nearest dollar. If an amount box does not require an entry, leave it blank. b. Determine the bond…arrow_forwardHome * CengageNOW x O Wayne Comm X w Course: 2021S x Course: 20215 x4 Chp 2 - Googl x+ w.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=... ☆ た eBook Show Me How Transactions Innovative Consulting Co. has the following accounts in its ledger: Cash, Accounts Receivable, Supplies, Office Equipment, Accounts Payable, Common Stock, Retained Earnings, Dividends, Fees Earned, Rent Expense, Advertising Expense, Utilities Expense, Miscellaneous Expense. Journalize the following selected transactions for October 20Y2 in a two-column journal. Journal entry explanations may be omitted. If an amount box does not require an entry, leave it blank. Oct. 1. Paid rent for the month, $2,500. 4. Paid advertising expense, $1,000. 5. Paid cash for supplies, $1,800. 6. Purchased office equipment on account, $11,500. 12. Received cash from customers on account, $7,500. 20. Paid creditor on account, $2,700. 27. Paid cash for miscellaneous expenses, $700. 30.…arrow_forwardEat min C e New tab Λ Content xW Quiz 3-MAT-143, section 03F, Fa X + Q A ✩ https://www.webassign.net/web/Student/Assignment-Responses/last?dep=34832472 Viewing Saved Work Revert to Last Response DETAILS MY NOTES You deposit $850 in an account paying an annual simple interest rate of 7.8%. Find the future value of the investment (in dollars) after 1 year. DETAILS MY NOTES Calculate the simple interest due (in dollars) on a 40-day loan of $1,600 if the annual interest rate is 9%. (Use 360 days in 1 year.) $ DETAILS MY NOTESarrow_forward
- Nonearrow_forwardMy question is How do I find the formula for Cell A11 and where do I need to calculate those so that I can work on that easily before putting in Excel?arrow_forwardMatch the words with the term. Question 13 options: 12345 mortgage 12345 trade receivables 12345 equipment 12345 working capital 12345 inventory 1. factoring 2. warehouse financing 3. line of credit 4. term loan 5. buildingarrow_forward
- What is the right answer from A to D? Please help mearrow_forwardOdysseyware LEARN MESSAGE HELP SIGN OUT ASSIGNMENTS COURSES Assignment -3. Automobile Loans Attempt 1 of 1 SECTION 4 OF 4 QUESTION 6 OF 6 1 2 3 4 >> Mark takes out a loan for $20,000. The loan has 2% interest rate and a 2.5% APR. Complete the following statement. The sum of the interest plus fees on this loan is $900 $500 $600 400 TURN IT IN O ASK FOR HELP 1124 PM SUBMIT ANSWER 40ENG 2/6/2021 P Type here to search Delete 144 BackncRce & % #3 8 7 2 3 4 P Y Uarrow_forwardOW21 Onlin teachin x N2 | Online teaching esource from Cengag... w.com eBook Cash Inventory Land Notes Payable tMain.do?invoker=&takeAssignmentSession Locator=&inprogress=false V Xi Lin, Capital Feedback ps Panthère de Cartier... ✓ Show Me How Journalizing Partner's Original Investment assumed a $57,000 note payable owed by Lin that was used originally to purchase the land. Xi Lin contributed land, inventory, and $35,000 cash to a partnership. The land had a book value of $79,000 and a market value of $152,000. The inventory had a book value of $53,100 and a market value of $48,900. The partnership also Required: Provide the journal entry for Lin's contribution to the partnership. If an amount box does not require an entry, leave it blank. 35,000 53,100 X 152,000 48,900 X 79,000 X 57,000 Pink Playful Femini... Check My Work 5 more Check My Work uses remaining. & MX Check My Work Record the assets at their current values, and record the liability at its current value. Lin's Capital…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning