Final test 1 2241
.xlsx
keyboard_arrow_up
School
Toronto Metropolitan University *
*We aren’t endorsed by this school
Course
ACC100
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
43
Uploaded by CoachProtonStingray38
Enter your name below in the yellow Enter your student number below in the yellow Avneet Sidhu
162029227
Nothing below here
nb
n.
Suburbia Shopping Mall
Your City
Company
Years
Expiration Date
Sq. Feet
Annual Rent
Fillards Dept Store
1/1/2010
5
1/1/2015 6,500 Boomingbales
1/1/2010
10
1/1/2020 6,750 Freddie Bauder
5/5/2011
3
5/5/2014 2,000 Inner Gap
12/1/2011
2
12/1/2013 3,250 Screaming Kids Inner Gap
7/1/2011
1
7/1/2012 2,150 Mallmart Cards
2/14/2010
5
2/14/2015 2,150 Hollingster
11/15/2011
2
11/15/2013 2,900 Fancy Jewelry Store
1/1/2010
4
1/1/2014 1,200 Spinster's Gifts
4/15/2011
1
4/15/2012 1,200 Waldo's Bookstore
5/17/2012
3
5/17/2015 2,150 Leasing Lookup Table
Price Per Sq Foot
Term (Years)
Regular
Adjusted
1
$ 25.00 $ 24.00 2
$ 22.49 $ 22.00 3
$ 19.99 $ 18.50 4
$ 19.23 $ 18.00 5
$ 19.00 $ 17.00 10
$ 16.99 $ 15.00 Constants
Square Footage Threshold
3,000 Months Per Year
12 Occupancy Date
Price per Sq Ft
The threshold in the
In this scenario, two kinds of rent can be a
threshold of the designated rent and the o
the designated rent, as shown in the table
the table to calculate the applicable rate p
logic functions if and vlookup. Anything el
Monthly Rent
e lookup
accessed/used. One is for below the other is above the threshold above e named “Leasing lookup table”. Use per square foot. You MUST use the lse is unacceptable.
Borrow
Lease
Lease value of Car
120000
125000
Down Payment
25%
10%
Length of lease in (years)
5
5
APR (annual interest rate)
5%
5%
Residual (Buy back)
20%
Monthly lease payment
Total interest paid on Loan
You ar
the le
1. Mo
2. Tota
re required to calculate two things in the space provided to eft:
onthly lease payment.
al interest paid
January
February
March
April
May
Monthlty descrease
10%
100000
110000
121000
133100
146410
NewFoundland
5000
5500
6050
6655
7321
PEI
3000
3300
3630
3993
4392
Nova Scotia
2000
2200
2420
2662
2928
Quebec
32000
35200
38720
42592
46851
Ontario
26000
28600
31460
34606
38067
Manitoba
10000
11000
12100
13310
14641
Sascatewan
6000
6600
7260
7986
8785
Alberta
8000
8800
9680
10648
11713
British Columbia
8000
8800
9680
10648
11713
Totals
100000
110000
121000
133100
146410
NewFoundland
5%
PEI
3%
Nova Scotia
2%
Quebec
32%
Ontario
26%
Manitoba
10%
Sascatewan
6%
Alberta
8%
British Columbia
8%
100%
There is an infectio
this infection based
absolute and mixed
your marks, you m
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
Need help with answering the questiins. Thank you
arrow_forward
https://sfdr.owschools.com/owsoo/studentAssignment/index?eh=65534403
SSIGNMENTS
Assignment - 1. Credit Scores and Loans
Attempt 1 of 1
COURSES
SECTION 3 OF 4
QUESTION
1
4
8
You get a personal loan of $5,000 with 12% simple interest too be paid over 30 months. What is your monthly payment?
O $150.00
O $166.67
O $216.67
O $175.00
NEXT QUESTION
O ASK FOR HELP
TURN IT IN
e to search
Pause
T
H
K
B
N
M
Alt
Ct
arrow_forward
Please help me solve it
arrow_forward
ting Principles, 13th Edition, Custom WileyPLUS Course for Bronx Community College
Return to Blackboard
SOFTWARE UPC
Help | System Announcements
macOS Big Sur 11.:
later tonight.
Problem 5A-3A
CALCULATOR
PF
Vaughn Corporation makes blenders (its merchandise) and entered into the following transactions during the month of September 2017.
Sept. 2
Purchased merchandise from Jones Company on credit for $4,330. Credit terms were 2/10, n/30.
Paid $240 for the delivery charges on the merchandise purchased on September 2.
5.
Purchased merchandise from Moses Company on credit for $4,270. Credit terms were 3/10, n/30.
6.
Sold merchandise for cash, $1,310.
8.
Purchased store equipment for $8,400 from Santa Corporation. A down payment of $3,900 was made, and a note was signed for the remaining balance.
6.
Sold merchandise on credit to Stephanie Company for $1,200. The credit terms of the sale were 3/15, n/45.
10
Returned $230 of defective merchandise to Jones Company and received the appropriate…
arrow_forward
how did they get 17.27 ? please no excel im tryign to master the steps
arrow_forward
Need help with this questiin please. Thank you
arrow_forward
Course: UNIV
University of the People
Borrowing
Your business requests a 3-month loan for
$500,000. What will be the interest paid at the
end of the term if the business risk percentage is
assessed at 2.2% and LIBOR is at 2.8%?
interest paid = $ [ ? ]
Round to the nearest hundredth.
Enter
right 2003-2021 Acellus Corporation. All Rights Reserved.
MacBook
80
888
DL
74
F8
&
arrow_forward
Need help plz
arrow_forward
RE U
Return to Blackboard
macOS Big Sur 1
later tonight.
IS Weygandt, Accounting Principles, 13th Edition, Custom WileyPLUS Course for Bronx Community College
Help | System Announcements
CALCULATOR
Exercise 9-15 a-c (Part Level Submission)
On May 2, Marigold Company lends $9,500 to Chang, Inc., issuing a 6-month, 8% note. At the maturity date, November 2, Chang indicates that it cannot pay.
(a)
Prepare the entry to record the issuance of the note. (Credit account titles are automatically indented when amount is entered. Do not indent manually
Date
Account Titles and Explanation
Debit
Credit
May 2
SHOW LIST OF ACCOUNTS
SA
Attempts: 0 of 1 used
> (b)
The parts of this question must be completed in order. This part will be available when you complete the part above.
arrow_forward
What will be interest paid?
arrow_forward
a grande songs-Google Se x
8.acellus.com/StudentFunctions/Interface/acellus_engine.html?ClassID=1977958208#
M My Gmail
My Classes
O My Drive - Google D..
O Algebi
des K to 12
Acellus - The Scienc..
Unit 6 Exam
Mortgage payments
How much money will
be spent in interest alone
over the course of the
4% 30-year mortgage
described in the table?
Principal: $200,000.00
Monthly
Payment
Interest
Rate
3%
4%
$843
$955
$1074
5%
A. $200,000
B. $343,800
C. $143,800
D. $8,000
rellus Corporation. All Rights Reserved.
arrow_forward
I could really use some help with this problem it’s due in a few hours thank you so much
arrow_forward
My Blackboard
MTH101 B01 - QUANTITATIVE LITERACY (Fall 2021 Credit Courses)
Homework
Homework 1.3
Homework 1.3
Score: 0/19
2/8 answered
X Question 3
>
Score on last try: 0 of 1 pts. See Details for more.
> Next question
2 Get a similar question You can retry this question below
You deposit $6000 in an account earning 5% interest compóunded monthly. How much will you have in the
account in 15 years?
$ 8,540.57
Question Help: Message instructor
Submit Question
МacBook Air
000
D00
F6
F5
F4
esc
F2
F3
F1
%24
并
arrow_forward
sd
subject-Accounting
arrow_forward
QUESTION 4
A flower shop owner wants to pay off the loan on a used delivery van that was purchased 32 months ago. The 4-year
installment plan used to purchase the van included a $250 finance charge and called for payments of $230 monthly. What
amount is needed to pay off the loan?
OA S3651.09
O B. $3734.47
OC S3677.51
O D.$3578.66
arrow_forward
Help please
arrow_forward
dbm 105 fund x DBM 105.pdf
Home
Question Z
Not yet answered
tps://eclass.uonbi.ac.ke/mod/quiz/attempt.php?attempt=876769&cmid=38254&page=1
Marked out of
10.00
Flag question
IO
X
Events
Dashboard
My Courses
This course
Joe Durango prepared the following trial balance from the accounting records of his firm, Dango
Traders.
TAKE AWAY CAT DUE SUNDAY 3 X
Sales
Sales Returns and Allowances
-
Durango Traders
Trial Balance
As at 31.7.2019
Purchases
Purchases Returns and Allowances
Freight-in
Advertisement
Salaries
Administrative Expenses
Stationery and Printing
Office Equipment at Cost
Accumulated Depreciation: Office
Equipment
Capital: J.Durango 1/8/2018
Drawings: J.Durango
Cash
Trade Debtors
Trading Inventory 1/8/2018
Prepaid Insurance
Dr.(Kshs) Cr.(Kshs)
675,000
2,250
436,500
11,700
2,250
52,200
3.150
4.050
27,000
45,000
78,235
10,350
70,650
1,620
3,150
10,125
49.480
CAT-LDP 109: FUNDAMENTALS x +
X
hp
W
arrow_forward
Cengage Learning
* CengageNOWv2 | Online teachin x
* Cengage Learning
Assignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress-false
eBook
Show Me How
Analysis of Receivables Method
At the end of the current year, Accounts Receivable has
balance of $4,375,000; Allowance for Doubtful Accounts has a debit balance of $21,300; and sale
for the year total $102,480,000. Using the aging method, the balance of Allowance for Doubtful Accounts is estimated as $205,000.
a. Determine the amount of the adjusting entry for uncollectible acfounts.
b. Determine the adjusted balances of Accounts Receivable, Allowance for Doubtful Accounts, and Bad Debt Expense.
Accounts Receivable
Allowance for Doubtful Accounts
Bad Debt Expense
c. Determine the net realizable value of accounts receivable.
Feedback
T Check My Work
The analysis of receivables method is based on the assumption that the longer an account receivable is outstanding the less likely that it will be
collected.
The…
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
PENDING
LICEN
PROPERT
Townhome
$335,000 Est. $1K/mo
7.8
2 bed 2.5 bath 1,376 sqft
400 E Guenther St Unit 3103,
San Antonio, TX 78210
Email Agent
PEN
2 b
400
Listi
You purchase the townhome listed above at realtor.com and borrow 95% of the listed price from
Broadway Bank at an APR of 6% with monthly payments (your down payment is 5% of listed
price). The maturity of your mortgage equals 30 years with monthly payments.
a. Draw a time line that depicts the cash flows from the mortgage payments- compute the
payment and show your inputs and work.
b. Compute the outstanding mortgage amount after you have made 15 years of payments.
i. Show this point on the time line, and
ii. give the inputs to your computations for full credit.
c. What is the interest and principal component of the next mortgage payment after making
payments for: 5 years, 15 years and 25 years.
arrow_forward
Return to Blackboard
US Weygandt, Accounting Principles, 13th Edition, Custom WileyPLUS Course for Bronx Community College
Help | System Announcements
Exercise 9-12 a-b (Part Levei SubmiSSion)
CES
CALCULATOR
PRINTER VERSION
4 ВАCK
Oriole Supply Co. has the following transactions related to notes receivable during the last 2 months of 2020. The company does not make entries to accrue interest excer
ES-
December 31.
Nov. 1 Loaned $23,500 cash to Manny Lopez on a 12-month, 12% note.
t
Sold goods to Ralph Kremer, Inc., receiving a $61,200, 90-day, 10% note.
Dec. 11
16
Received a $97,200, 180 day, 8% note in exchange for Joe Fernetti's outstanding accounts receivable.
31
Accrued interest revenue on all notes receivable.
(a)
Your answer is correct.
Journalize the transactions for Oriole Supply Co. (Ignore entries for cost of goods sold.) (Credit account titles are automatically indented when amount is ente
indent manually. Use 360 days for calculation. Round answers to 0 decimal places, e.g.…
arrow_forward
Assume that all interest is simple interest.
Fred started a new e-Commerce business and borrowed $14,800 for 10 years to get the business up and running. The interest is $4440. Find the rate. Round to
two decimal places, if necessary.
The interest rate for Fred's loan is
Check
68°F
Clear
#3
$
A
IOI
WER
%.
5
T
6
X
●
Search
&
7
S
U
*
8
9
f10
Save For Later
© 2023 McGraw Hill LLC. All Rights Reserved. Terms of Use | Privacy Center | Accessibility
a
8:53 PM
6/12/2023
► 11
O
fm
P
W
(12
ins
Submit Assignment
prt sc
delete
backspace
3.: 0
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Need help with this question please. Thank you
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Please answer fast without plagiarism please will upvote
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
Digital Learning
* CengageNOwv2 | Online teachir
* Cengage Learning
+
Assignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
A eBook
Show Me How
Percent of Sales Method
At the end of the current year, Accounts Receivable has a balance of $555,000; Allowance for Doubtful Accounts has a credit balance of $5,000; and sales for
the year total $2,500,000. Bad debt expense is estimated at 1/4 of 1% of sales.
a. Determine the amount of the adjusting entry for uncollectible accounts.
b. Determine the adjusted balances of Accounts Receivable, Allowance for Doubtful Accounts, and Bad Debt Expense.
Accounts Receivable
24
Allowance for Doubtful Accounts
Bad Debt Expense
%24
c. Determine the net realizable value of accounts receivable.
Feedback
Check My Work
a. Remember that since accounts receivable are created by credit sales, uncollectible accounts çan be estimated as a percent of credit sales. If the
portion of credit sales to sales id relatively constant, the…
arrow_forward
vileyplus.com/edugen/lti/main.uni
Kimmel, Financial Accounting, 8e
Help I System Announcements
Brief Exercise 10-4
Your answer is partially correct. Try again.
Bramble University sells 6,500 season basketball tickets at $40 each for the entire 13-ga
(e)
Give the entry to record the sale of the season tickets. (Credit account titles are auto
Account Titles and Explanation
Debit
Credit
Cash
00009
Unearned Service Revenue
00009
Sive the entry to record the revenue recognized after playing the first home game. (Cre
Account Titles and Explanation
Debit
Credit
Unearned Service Revenue
00000
Sales Revenue
000001
lick if you would like to Show Work for this question: Open Show Work
arrow_forward
* 100 ll
2 p E:YA
2_54180033916640...
Sonia opens a plastic bag shop in Kangar. She rent shop lots, purchases an initial stock of plastics
bag, and begins operations. Complete are the general journal entries for the first month
Date
Account name and explanation
debit
credit
01/03/2010
A/C
10,000
A/C-
10,0000
Owner contributes $10,000 in cash to start the business
05/03/2010
A/C-
4000
AC-
4000
Purchased $4000 plastic bags on account, payable in 30 days.
05/03/2010
A/C-
1000
AC
1000
Paid shop rental of $1000.
09/03/2010
A/C
-?
500
AC-
500
Customer buy goods for cash.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- Need help with answering the questiins. Thank youarrow_forwardhttps://sfdr.owschools.com/owsoo/studentAssignment/index?eh=65534403 SSIGNMENTS Assignment - 1. Credit Scores and Loans Attempt 1 of 1 COURSES SECTION 3 OF 4 QUESTION 1 4 8 You get a personal loan of $5,000 with 12% simple interest too be paid over 30 months. What is your monthly payment? O $150.00 O $166.67 O $216.67 O $175.00 NEXT QUESTION O ASK FOR HELP TURN IT IN e to search Pause T H K B N M Alt Ctarrow_forwardPlease help me solve itarrow_forward
- ting Principles, 13th Edition, Custom WileyPLUS Course for Bronx Community College Return to Blackboard SOFTWARE UPC Help | System Announcements macOS Big Sur 11.: later tonight. Problem 5A-3A CALCULATOR PF Vaughn Corporation makes blenders (its merchandise) and entered into the following transactions during the month of September 2017. Sept. 2 Purchased merchandise from Jones Company on credit for $4,330. Credit terms were 2/10, n/30. Paid $240 for the delivery charges on the merchandise purchased on September 2. 5. Purchased merchandise from Moses Company on credit for $4,270. Credit terms were 3/10, n/30. 6. Sold merchandise for cash, $1,310. 8. Purchased store equipment for $8,400 from Santa Corporation. A down payment of $3,900 was made, and a note was signed for the remaining balance. 6. Sold merchandise on credit to Stephanie Company for $1,200. The credit terms of the sale were 3/15, n/45. 10 Returned $230 of defective merchandise to Jones Company and received the appropriate…arrow_forwardhow did they get 17.27 ? please no excel im tryign to master the stepsarrow_forwardNeed help with this questiin please. Thank youarrow_forward
- Course: UNIV University of the People Borrowing Your business requests a 3-month loan for $500,000. What will be the interest paid at the end of the term if the business risk percentage is assessed at 2.2% and LIBOR is at 2.8%? interest paid = $ [ ? ] Round to the nearest hundredth. Enter right 2003-2021 Acellus Corporation. All Rights Reserved. MacBook 80 888 DL 74 F8 &arrow_forwardNeed help plzarrow_forwardRE U Return to Blackboard macOS Big Sur 1 later tonight. IS Weygandt, Accounting Principles, 13th Edition, Custom WileyPLUS Course for Bronx Community College Help | System Announcements CALCULATOR Exercise 9-15 a-c (Part Level Submission) On May 2, Marigold Company lends $9,500 to Chang, Inc., issuing a 6-month, 8% note. At the maturity date, November 2, Chang indicates that it cannot pay. (a) Prepare the entry to record the issuance of the note. (Credit account titles are automatically indented when amount is entered. Do not indent manually Date Account Titles and Explanation Debit Credit May 2 SHOW LIST OF ACCOUNTS SA Attempts: 0 of 1 used > (b) The parts of this question must be completed in order. This part will be available when you complete the part above.arrow_forward
- What will be interest paid?arrow_forwarda grande songs-Google Se x 8.acellus.com/StudentFunctions/Interface/acellus_engine.html?ClassID=1977958208# M My Gmail My Classes O My Drive - Google D.. O Algebi des K to 12 Acellus - The Scienc.. Unit 6 Exam Mortgage payments How much money will be spent in interest alone over the course of the 4% 30-year mortgage described in the table? Principal: $200,000.00 Monthly Payment Interest Rate 3% 4% $843 $955 $1074 5% A. $200,000 B. $343,800 C. $143,800 D. $8,000 rellus Corporation. All Rights Reserved.arrow_forwardI could really use some help with this problem it’s due in a few hours thank you so mucharrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education