00 01 Assignment Sp 2024 (student)
.docx
keyboard_arrow_up
School
University of Notre Dame *
*We aren’t endorsed by this school
Course
5432
Subject
Finance
Date
Apr 3, 2024
Type
docx
Pages
4
Uploaded by DeanUniverseAardvark10 on coursehero.com
Name:
Assignment #1 (ARM vs. FRM over time)
Real Estate Finance
Dr. Conklin
Due by 8:59am on the due date (see eLC for due date)
; eLC assignment drop box will close at this time;
no late assignments accepted; also must hand in a hard copy
of Answer Sheet tab in class on due date
)
Instructions:
This is an individual assignment. Each student should create their own deliverables. You are not allowed
discuss the assignment with classmates. Posted on the course website is a spreadsheet titled “00 01 Interest Rate Data” that is to be used for this assignment. Download the spreadsheet and complete the following tasks. You will need to use absolute and mixed references in this and future assignments (for a brief tutorial see http://www.excel-easy.com/functions/cell-references.html
). Since Excel is the industry standard, a goal of this assignment is to get you familiar with some of the TVM concepts within Excel as they apply to mortgages. We discussed the differences between adjustable and fixed rate mortgages. Now, we want to perform some analysis with some actual data to put what we’ve learned into practice. The goal of this assignment is to look at what you would have paid on each type of loan, had you chosen it at a specific point in time. For example, if you chose an ARM in 2001 and held onto it for five years, would you have paid more than if you selected a fixed rate mortgage in 2001 with the same holding period?
Download the “00 01 interest rate data” spreadsheet on eLC. The data contains historical interest rate data in the “Rates and Points” tab.
1
The 30 year rate column has the 30 year FRM rate for the given year. The 30 year points column has the fees (in percentage terms) that you would have paid to get that
rate. So, for example, if you took out a 30 year FRM in 1988 your interest rate would have been 10.34% and you would have paid 2.06 points to get the loan. The spreadsheet also contains interest rate information for a one year adjustable rate mortgage. The 1 year index column is the one year constant maturity treasure (CMT) rate that serves as the index for the mortgage. The 1 year margin is the margin on the 1 year ARM originated in that given year. The 1 year points column gives the points to get the 1 year ARM loan. So, if you took out a 1 year ARM in 1988, you
would pay 2.29 points at origination, and your rate for the first year would be 10.4% (7.65% + 2.75%). In
1989, your rate on this loan (that you took out in 1988) would be 11.28% (8.53% + 2.75%
). For each year from 1988 to 2011, I want you to compute the all-in costs for a $500,0000 FRM and a $500,000 ARM. Assume each type of loan is amortized over 30 years, with monthly payments, and that your holding period for the loan is 5 years (e.g., you will pay off the remaining balance at the end of 5 1
Underlying data:
http://www.freddiemac.com/pmms/pmms_archives.html
; https://fred.stlouisfed.org/series/DGS1
years). The all in costs should be in dollar terms (all-in costs = points at origination + total of monthly payments over holding period + remaining mortgage balance at the end of year 5). In calculating the all in costs, make sure that your spreadsheet is flexible. If, for example, I wanted to see the all in costs over
the different years for a $600,000 loan, I should just be able to change an input cell for loan amount, and
all of the calculations (and graphs discussed below) should update accordingly. This means you will probably want to think carefully about how you set up your spreadsheets/calculations ahead of time (Hint: You should not be calculating everything by hand and just manually entering it into the spreadsheet. But, it probably makes sense to manually check in your financial calculator some of the calculations in Excel. This is particularly important so that you can be confident that your absolute and mixed cell references are working the way you think they are. In fact, this is exactly what I did when I created and completed the assignment myself). You have a lot of freedom in how you set up your spreadsheets/calculations, and there is no single “right” way to do it. I would suggest that you do most of the grunt work in a sheet other than the Answer Sheet Tab. The Answer Sheet Tab should be fairly “clean” as you will be printing this out as part of your deliverables. There is interest rate data through 2015, but you are only calculating all-in costs for loans originated up until year 2011 because you need 5 years of ARM index data to calculate the ARM all-in costs. Here is the information I would like you to complete in the “Answer Sheet” tab. By the end of the assignment, all yellow highlighted cells should be filled out:
1)
Put your name (first and last) in cell B1 in the “Answer Sheet” tab. Put your UGA ID # in cell A2. Put your section time (12:45 or 2:20) in cell A3. 2)
Put the all in costs for a FRM (ARM) originated in each year in cells B7 – B30 (C7 – C30). In cells D7 – D30, put the differences in all-in costs between the two (FRM – ARM).
3)
Create a graph that plots the all-in costs of the 30 year FRM and 1 year ARM over time (you should use a scatter plot to do this; this can be found under the “Insert\Charts” tab at the top of the spreadsheet). There should be two different lines on the chart. Year should be on the X-
axis. Title the graph “Total Costs FRM vs. ARM.” Also include a legend for the lines and anything
else you think is appropriate. Basically, make your graph look professional (presentation will count towards your grade). Make the minimum value on the Y-axis $500,000 so that it is easier to interpret the graph.
4)
Create a separate
graph that plots the difference in all-in costs (FRM – ARM) over time. Title the graph “Additional Cost on 30 Year FRM $500,000 Loan with 5 Year Holding Period.” Adjust the formatting of the graph to make it look professional. 5)
In how many years (and what fraction of total years), would you have paid more by taking out the FRM? Put your answers in cells E33 and E34.
6)
What is the maximum dollar benefit of the ARM over these years? Put your answer in cell E36.
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
1. Prepare the required Ledger Accounts as per the case given below.
Requirement: The students are required to post the journal entries to the general ledger accounts below
covering the period from March 1 to 31, 2021 these journal entries were taken from the accounting
books of AL Almas Shope owned and managed by Ms. Nabila.
• All Ledger accounts must be dosed.
The account total and balance are required to be determined after completing all postings for all
Ledger accounts
• The students must use the general ledgers accounts mentioned in this assessment paper and use
the correct template.
• You are not required to fill-up the reference columns in the general ledgers.
March. Particulars
Ref. Debit
Credit
Date
2021
1
Cash
200,000
Capital
200,000
To record owner's capital invested in Business
2
Furniture
7,000
Cash
7,000
To record purchase of Fumiture by cash from Danube Furniture
Land
15,000
Accounts Payable
15,000
To record purchase of Land on credit from Mr. Said
6.
Cash
2,000
Loans…
arrow_forward
Only typed solution.
When an attest client has unpaid fees that are over one year past due, what is required?
A) There are no requirements in this situationB) Obtain a note receivable from the clientC) Move forward with the attest work as long as the client says they will pay us soonD) Consult with National Independence
arrow_forward
Can you plz just do the last 2 which will be in the picture and the 1st picture going to be the answer for the first 3 thats already answerd
thank you in advance
Financial Statements and Closing Entries
Last Chance Company offers legal consulting advice to prison inmates. Last Chance Company prepared the end-of-period spreadsheet that follows at June 30, 20Y1, the end of the fiscal year:
Last Chance Company
End-of-Period Spreadsheet
For the Year Ended June 30, 20Y1
Unadjusted
Adjusted
Trial Balance
Adjustments
Trial Balance
Account Title
Dr.
Cr.
Dr.
Cr.
Dr.
Cr.
Cash
5,100
5,100
Accounts Receivable
22,750
(a)
3,750
26,500
Prepaid Insurance
3,600
(b)
1,300
2,300
Supplies
2,025
(c)
1,500
525
Land
80,000
80,000
Building
340,000
340,000
Accum. Depr.—Building
190,000
(d)
3,000
193,000
Equipment
140,000
140,000
Accum.…
arrow_forward
Do not copy from bartleby. Otherwisw i will give you dislike
When DeSoto Water Works purchased equipment at the end of 2020 at a cost of $64,000, the company debited Buildings and credited Cash $64,000. The error was discovered in 2021. Prepare the journal entry DeSoto will use to correct the error. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) View transaction list Journal entry worksheet 1 Record entry to correct error. Note: Enter debits before credits. Event General Journal Debit Credit 1 Record entry Clear entry View general journal
arrow_forward
EX
Fri Apr 30 6:26 PM
iew
History
Bookmarks
Window
Help
A edugen.wileyplus.com
Return to Blackboard
PLUS
Weygandt, Accounting Principles, 13th Edition, Custom WileyPLUS Course for Bronx Community College
Help | System Announcements
CALCULATOR
PRINTER VERSION
4 ВАCK
NEXT
URCES
Exercise 9-06 a-b (Part Level Submission)
ents-
Cheyenne Company has accounts receivable of $108,000 at March 31, 2020. Credit terms are 2/10, n/30. At March 31, 2020, there is a $1,400 credit balance in Allowance for
Doubtful Accounts prior to adjustment. The company uses the percentage-of-receivables basis for estimating uncollectible accounts. The company's estimate of bad debts is shown
below.
Part
Part
Estimated
Percentage
Uncollectible
art
Balance,
Age of Accounts
March 31
2020
2019
Current
$64,800 $75,000
2%
1-30 days past due
25,200
8,000
7%
31-90 days past due
9,600
2,400
22%
Over 90 days past due
8,400
1,100
50%
$108,000 $86,500
00
arrow_forward
Spring 2021 Final Exam(2) - Saved to this PC -
erences
Mailings
Review
View
Help
三 三|A|T
AaBbCcD AaBbCcDc AaBbC AABBCCC AaB
I Normal
T No Spac... Heading 1
Heading 2
Title
Paragraph
Styles
3-Michael Cool's employer offers its workers an optional two-month unpaid vacation after 7
years of service to the firm, who just started working for the firm, plans to spend his vacation
touring Europe at an estimated cost of $24,000. To finance his trip, Robert plans to make an
annual deposit of $2,500 into a savings account at the end of the next seven years (first deposit
will occur one year from today. The account pays 8% annual interest rate,
a. Will Michael's account balance in seven years be enough to pay for his trip?
b. Suppose Michael increases his annual deposit to S2,700. How large will his account
balance be in seven years?
4- The Robinson Company has the following current assets and current liabilities for these two
arrow_forward
Question 25 of 30 . True or False - When creating a time slip in Sage 50, you can only enter the time using the available timer. True False
26 of 30. True or False - Prior to creating time slips in Sage 50, you need to set up service activity items. ) True False
27 of 30 What can time slips be used for in Sage 50 Premium Accounting? Select ALL that apply.,
To bill customers for the hours or fime spent on activities
To pay employees based on the number of hours spent on various activities
To create purchase invoices based on the activites.
To create purchase quoles based on the time spent on activities Mark for follow up
arrow_forward
A nail salon received an invoice from a supplier for $1400 dated September 19 with terms 5/10, 2/20, n/60 E.O.M. What is the last day to receive a 2% discount? (Do not use a number for the month.
Please write the full word.)
« »
A Moving to another question will save this response.
3:07 PM
PS
底 4)
%3D
O Type here to search
-4°C
2/24/2022
arrow_forward
The company el Ahuehuete, S.A., shows you the data of the credit applicants. Without knowing the rules and credit policies of this company. Each case will provide conditions for you to establish minimum criteria for granting credit. Once you have reached an agreement as a team, review who would be subject to credit according to these new policies that have been established.
Dinora Velázquez. Homemaker. She manages the household and budgeted monthly household expenses amount to $16,000.00. Her husband is the breadwinner; he is a maquila worker and earns $30,000.00. They have 2 elementary school age children. She has a mortgage on the house they live in, which takes 20% of her family's income.
Subject to credit? Would it be good for the company to lend you credit?
arrow_forward
This window shows your responses and what was marked correct and Incorrect from your prevlous attempt.
Required Informatlon
Problem 13-63 & Problem 13-64 (Algo) (LO 13-5, 6, 7, 9)
The following information applies to the questions displayed below]
Jeremy Slacker started the Del Fuego Surf Shop on January 1 after determining that business school classes conflicted
with his preferred activity. He invested $64,000 in the shop-$50,980 of his own savings and $32,000 borrowed from an
acquaintance. The loan is to be repaid in 5 years. Jeremy will pay the lender annual interest at a rate of 8 percent.
ded
Shortly after opening, Jeremy realized that he is not the best financial planner and has come to you for help. With some
prodding, you are able to establish that Jeremy plans to sell only two models of surfboard, the Zuma and the Coronado,
for at least the first year. Data on the boards are given as follows,
Coronado
) zuma
816
408
Expected annual sales (units)
$720
470
$420
Retail price (per…
arrow_forward
please answer all the parts of the question within 30 minutes. make sure the calculations are explained in very detailed manner also formatting of journal entries and accounts is proper, Attempt the answer only if your are 100% sure that its correct. else leave it for other tutore otherwise i will give negative ratings and will also report your answer for unprofessionalism. Make sure the answer shows detailed calculations and is 100% correct. ATTEMPT ONLY IF YOU ARE 100% SURE AND ANSWER WILL BE CORRECT.
arrow_forward
Teal Company is presently testing a number of new agricultural seed planters that it has recently developed. To stimulate interest, it
has decided to grant to five of its largest customers the unconditional right of return to these products if not fully satisfied. The right of
return extends for 4 months. Teal estimates returns of 20%. Teal sells these planters on account for $1,500,000 (cost $825,000) on
January 2, 2020. Customers are required to pay the full amount due by March 15, 2020.
Your answer is correct.
Prepare the journal entry for Teal at January 2, 202o. (Credit account titles are automatically indented when amount is entered. Do not
indent manually. If no entry is required, select "No entry" for the account titles and enter O for the amounts.)
Date
Account Titles and Explanation
Debit
Credit
Jan. 2,
Accounts Receivable
1,500,000
2020
Sales Revenue
1,500,000
(To recognize revenue.)
Cost of Goods Sold
825000
Inventory
825000
(To record cost of goods sold.)
eTextbook and…
arrow_forward
I need to create a journal entry for my accounting class. Here is the question: May 8: Sign a letter of intent to switch electric suppliers starting in June. I believe no journal entry is required?
arrow_forward
what is the correcting entry for.. billing a customer for $2500 for photocopy work
arrow_forward
Open T accounts and post the journal entries to the general ledger. N(Post entries in the order of journal entries presented in the previous part Select the date for closing balanceseven in case of zero balance. If ending balance is 0, enter 0 on the normal sicde for the account)
June 1Samantha Miller opened Miller Real Estate Agency with an investment of $13,220 cash and $2,850 of equipment.2Paid $1,260 for a one-year insurance policy.3Purchased additional equipment for $4,520, paying $760 cash and signing a note payable for the balance.10Received $355 cash as a fee for renting an apartment.16Sold a house and lot for B. Wilson. The cormmission due from Wilson is $7,330. {It is not paid by Wilson at this time.)27Paid $750 for advertising to run during June.29Received an $80 bill for telephone service during the month of June. (The bill is paid in July)30Paid an administrative assistant $2,390 in salary for June.30Received $7,330 cash from B. Wilson for the June 16 transaction.
arrow_forward
The work sheet for Major Advising to complete this exercise is as follows.
1. Prepare the closing entries. If an amount box does not require an entry, leave it blank. Do not enter the posting references until you complete part 2.
2. Post the closing entries to the T accounts. If there is more than one closing entry for an account, enter in the order given in the journal. Then complete the posting in part 1.
Major AdvisingWork Sheet (Partial)For Month Ended January 31, 20 --
Income Statement
Balance Sheet
Account Title
Debit
Credit
Debit
Credit
Cash
1,342
Accounts Receivable
933
Supplies
335
Prepaid Insurance
856
Office Equipment
3,510
Accum. Depr.—Office Equipment
185
Accounts Payable
981
Wages Payable
319
Ed Major, Capital
4,147
Ed Major, Drawing
915
Advising Fees
4,199
Wages Expense
738
Advertising Expense
94
Rent Expense
499
Supplies Expense
126
Phone…
arrow_forward
Renzo is attending his first virtual meeting. Which of the following statements would be good advice for Renzo?
Don't mute your phone during the meeting so you don't miss important calls.
Log in 15 minutes early.
Log in on time.
It's okay not to say anything in your first meeting.
arrow_forward
Post the journal entries for the transactions to the following t-accounts. Each of which started the month with a zero balance.
*****the drop down options for the first column are: a., b(1), b(2), c(1), c(2), d., e., f., g., h., i.
For columns 2 and 3 you input a number
for column 4 the drop down options are: a., b(1), b(2), c(1), c(2), d., e., f., g., h., i.
to clarify, column 1 starts at the top and ends with "ending balance"
column 2 starts at the top and ends with "0" in the photos provided
Please don't add numbers to columns 1 or 4 only the drop down letters. Thank you!
arrow_forward
Use the following partial listing of T accounts to complete this exercise.
1. Prepare closing entries dated January 31, 20--. Do not enter the posting references until you have completed part 2. If an amount box does not require an entry, leave it blank.
2. Post the closing entries to the T accounts following the top-down journal entry order. If there is more than one closing entry for an account, enter in the order given in the journal above. Then, complete the posting for part 1.
Closing Entries (Net Loss)
Accum. Depr.—Delivery Equip
185.1
Bal.
100
Wages Payable
219
Bal.
200
Kylea Vasquez, Capital
311
Bal.
4,000
Kylea Vasquez, Drawing
312
Bal.
800
Income Summary
313
Delivery Fees
401
Bal.
2,200
Wages Expense
511
Bal.
1,710
Advertising Expense
512
Bal.
80
Rent Expense
521
Bal.
400
Supplies Expense
523
Bal.
120
Phone Expense
525
Bal.
58…
arrow_forward
þ. Post the journal entries in the ledger accounts on the next page for Sheila McFarlane, a lawyer,
and take off a trial balance on the form provided.
GENERAL JOURNAL
PAGE
DATE
PARTICULARS
P.R.
DEBIT
CREDIT
20-
Mar.
4 00 0
100
20 0
2 00 0
31 Bank
A/RJim Shearer
Supplies
Office Equipment
A/P-Elite Equipment
A/P-Legal Publishers
Bank Loan
Shella McFarlane, Capital
1 00 0
500
300 0
2 700
Apr.
2 Bank
60 0
60 0
ARJim Shearer
3 A/P-Elite Equipment
Bank
4 0 0
400
5 Bank
2l 5 0
25 0
Fees Earned
20 0
15 Sheila McFarlane, Drawings
Bank
200
20 Bank
2 00 o
200 0
Bank Loan
GENERAL JOURNAL
PAGE
DATE
20-
Apr.
PARTICULARS
P.R.
DEBIT
CREDIT
25 Repairs Expense
5 0
Bank
5 0
26 Bank
170
Sheila MacFarlane, Capital
Office Equipment
4 20
30 A/P-Legal Publishers
Bank
5 00
5 00
arrow_forward
Odysseyware
Ô https://sfdr.owschools.com/ows00/studentAssignment/index?eh=65534412
San Felipe Del RIO CISD-TIS
JALYN GARCIA
Odysseyware
LEARN
MESSAGE
HELP
SIGN OUT
Assignment - 3. Automobile Loens
Attempt 1 of 1
ASSIGNMENTS
COURSES
SECTION 2 OF 4
QUESTION 2 OF 6
《く
11
4 5 6
3
> »
Miguel takes a car loan for $16,000. The loan is for 60 months and has an interest rate of 4%. There are an additional
$1,000 of fees. What is the APR for this loan?
O 6.25%
O 6.4%
O 8.6%
O 10.25%
NEXT QUESTION
O ASK FOR HELP
TURN IT IN
P Type here to search
11:20 PM
G 10 ENG
2/6/2021
G
C
2N
M
中 o
arrow_forward
remier nati
ation online, we know that By
peing shared on the Internet especially in con
ino Independence every 12th of June, and Rizal's martyre
can be seen in monuments, t-shirts, money, and
NAME:
SCORE:
SECTION:
PROFESSOR:
Problem #5
Analysis of the Income Summary Account
The following is the income summary account of Rosemarie Español Services on D
2020, after all revenue and expenses have been closed to the account.
Income Summary
197,000
190,000
Required:
1. What do the figures in the account represent?
2. What is the profit or loss?
3. Close the income summary account.
arrow_forward
prepare closing entries for temporary accounts in problem 6-9A on page 206/207 in the new book and page 204 in the old book. Autumn's Home Designs. Journalize closing entries and prepare the post closing trial balance.
arrow_forward
4.
5.
6.
What accounts are considered temporary accounts? Hint: Use the broad categories that we
have discussed since day one in class. Otherwise, give at least three examples of specific
accounts.
What financial statement does all the permanent accounts get listed on?
With the following accounts please tell me what the normal account balance would be. Keep in
mind of your hints that I have given you throughout the semester so far.
Account name
Cash
Dividends
Accounts Payable
Retained Earnings
Prepaid Insurance
Telephone expense
Commissions Earned
oft
Normal Balance
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Related Questions
- 1. Prepare the required Ledger Accounts as per the case given below. Requirement: The students are required to post the journal entries to the general ledger accounts below covering the period from March 1 to 31, 2021 these journal entries were taken from the accounting books of AL Almas Shope owned and managed by Ms. Nabila. • All Ledger accounts must be dosed. The account total and balance are required to be determined after completing all postings for all Ledger accounts • The students must use the general ledgers accounts mentioned in this assessment paper and use the correct template. • You are not required to fill-up the reference columns in the general ledgers. March. Particulars Ref. Debit Credit Date 2021 1 Cash 200,000 Capital 200,000 To record owner's capital invested in Business 2 Furniture 7,000 Cash 7,000 To record purchase of Fumiture by cash from Danube Furniture Land 15,000 Accounts Payable 15,000 To record purchase of Land on credit from Mr. Said 6. Cash 2,000 Loans…arrow_forwardOnly typed solution. When an attest client has unpaid fees that are over one year past due, what is required? A) There are no requirements in this situationB) Obtain a note receivable from the clientC) Move forward with the attest work as long as the client says they will pay us soonD) Consult with National Independencearrow_forwardCan you plz just do the last 2 which will be in the picture and the 1st picture going to be the answer for the first 3 thats already answerd thank you in advance Financial Statements and Closing Entries Last Chance Company offers legal consulting advice to prison inmates. Last Chance Company prepared the end-of-period spreadsheet that follows at June 30, 20Y1, the end of the fiscal year: Last Chance Company End-of-Period Spreadsheet For the Year Ended June 30, 20Y1 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 5,100 5,100 Accounts Receivable 22,750 (a) 3,750 26,500 Prepaid Insurance 3,600 (b) 1,300 2,300 Supplies 2,025 (c) 1,500 525 Land 80,000 80,000 Building 340,000 340,000 Accum. Depr.—Building 190,000 (d) 3,000 193,000 Equipment 140,000 140,000 Accum.…arrow_forward
- Do not copy from bartleby. Otherwisw i will give you dislike When DeSoto Water Works purchased equipment at the end of 2020 at a cost of $64,000, the company debited Buildings and credited Cash $64,000. The error was discovered in 2021. Prepare the journal entry DeSoto will use to correct the error. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) View transaction list Journal entry worksheet 1 Record entry to correct error. Note: Enter debits before credits. Event General Journal Debit Credit 1 Record entry Clear entry View general journalarrow_forwardEX Fri Apr 30 6:26 PM iew History Bookmarks Window Help A edugen.wileyplus.com Return to Blackboard PLUS Weygandt, Accounting Principles, 13th Edition, Custom WileyPLUS Course for Bronx Community College Help | System Announcements CALCULATOR PRINTER VERSION 4 ВАCK NEXT URCES Exercise 9-06 a-b (Part Level Submission) ents- Cheyenne Company has accounts receivable of $108,000 at March 31, 2020. Credit terms are 2/10, n/30. At March 31, 2020, there is a $1,400 credit balance in Allowance for Doubtful Accounts prior to adjustment. The company uses the percentage-of-receivables basis for estimating uncollectible accounts. The company's estimate of bad debts is shown below. Part Part Estimated Percentage Uncollectible art Balance, Age of Accounts March 31 2020 2019 Current $64,800 $75,000 2% 1-30 days past due 25,200 8,000 7% 31-90 days past due 9,600 2,400 22% Over 90 days past due 8,400 1,100 50% $108,000 $86,500 00arrow_forwardSpring 2021 Final Exam(2) - Saved to this PC - erences Mailings Review View Help 三 三|A|T AaBbCcD AaBbCcDc AaBbC AABBCCC AaB I Normal T No Spac... Heading 1 Heading 2 Title Paragraph Styles 3-Michael Cool's employer offers its workers an optional two-month unpaid vacation after 7 years of service to the firm, who just started working for the firm, plans to spend his vacation touring Europe at an estimated cost of $24,000. To finance his trip, Robert plans to make an annual deposit of $2,500 into a savings account at the end of the next seven years (first deposit will occur one year from today. The account pays 8% annual interest rate, a. Will Michael's account balance in seven years be enough to pay for his trip? b. Suppose Michael increases his annual deposit to S2,700. How large will his account balance be in seven years? 4- The Robinson Company has the following current assets and current liabilities for these twoarrow_forward
- Question 25 of 30 . True or False - When creating a time slip in Sage 50, you can only enter the time using the available timer. True False 26 of 30. True or False - Prior to creating time slips in Sage 50, you need to set up service activity items. ) True False 27 of 30 What can time slips be used for in Sage 50 Premium Accounting? Select ALL that apply., To bill customers for the hours or fime spent on activities To pay employees based on the number of hours spent on various activities To create purchase invoices based on the activites. To create purchase quoles based on the time spent on activities Mark for follow uparrow_forwardA nail salon received an invoice from a supplier for $1400 dated September 19 with terms 5/10, 2/20, n/60 E.O.M. What is the last day to receive a 2% discount? (Do not use a number for the month. Please write the full word.) « » A Moving to another question will save this response. 3:07 PM PS 底 4) %3D O Type here to search -4°C 2/24/2022arrow_forwardThe company el Ahuehuete, S.A., shows you the data of the credit applicants. Without knowing the rules and credit policies of this company. Each case will provide conditions for you to establish minimum criteria for granting credit. Once you have reached an agreement as a team, review who would be subject to credit according to these new policies that have been established. Dinora Velázquez. Homemaker. She manages the household and budgeted monthly household expenses amount to $16,000.00. Her husband is the breadwinner; he is a maquila worker and earns $30,000.00. They have 2 elementary school age children. She has a mortgage on the house they live in, which takes 20% of her family's income. Subject to credit? Would it be good for the company to lend you credit?arrow_forward
- This window shows your responses and what was marked correct and Incorrect from your prevlous attempt. Required Informatlon Problem 13-63 & Problem 13-64 (Algo) (LO 13-5, 6, 7, 9) The following information applies to the questions displayed below] Jeremy Slacker started the Del Fuego Surf Shop on January 1 after determining that business school classes conflicted with his preferred activity. He invested $64,000 in the shop-$50,980 of his own savings and $32,000 borrowed from an acquaintance. The loan is to be repaid in 5 years. Jeremy will pay the lender annual interest at a rate of 8 percent. ded Shortly after opening, Jeremy realized that he is not the best financial planner and has come to you for help. With some prodding, you are able to establish that Jeremy plans to sell only two models of surfboard, the Zuma and the Coronado, for at least the first year. Data on the boards are given as follows, Coronado ) zuma 816 408 Expected annual sales (units) $720 470 $420 Retail price (per…arrow_forwardplease answer all the parts of the question within 30 minutes. make sure the calculations are explained in very detailed manner also formatting of journal entries and accounts is proper, Attempt the answer only if your are 100% sure that its correct. else leave it for other tutore otherwise i will give negative ratings and will also report your answer for unprofessionalism. Make sure the answer shows detailed calculations and is 100% correct. ATTEMPT ONLY IF YOU ARE 100% SURE AND ANSWER WILL BE CORRECT.arrow_forwardTeal Company is presently testing a number of new agricultural seed planters that it has recently developed. To stimulate interest, it has decided to grant to five of its largest customers the unconditional right of return to these products if not fully satisfied. The right of return extends for 4 months. Teal estimates returns of 20%. Teal sells these planters on account for $1,500,000 (cost $825,000) on January 2, 2020. Customers are required to pay the full amount due by March 15, 2020. Your answer is correct. Prepare the journal entry for Teal at January 2, 202o. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No entry" for the account titles and enter O for the amounts.) Date Account Titles and Explanation Debit Credit Jan. 2, Accounts Receivable 1,500,000 2020 Sales Revenue 1,500,000 (To recognize revenue.) Cost of Goods Sold 825000 Inventory 825000 (To record cost of goods sold.) eTextbook and…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengagePrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,