Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Question
Use excel to calculate the total interest on a $ 731,242 loan for a small business making monthly payments with an interest rate of 4% over 20 years. Round your answer to the nearest hundredth and enter your answer as a positive number. Please help I do not have excel
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
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
- Answer in excel 3. You have just received an email inviting you to accept a new credit card that offers you a $12,000 credit limit based upon your FICO score. You realize you can use that card now to charge your long overdue upscale vacation, which will cost $7500. The introductory terms of your new card indicates that no payment is due for the next two years, and the amount due will be charged a low 3% every month until you repay. Assuming you wait the full two years, how much will you owe at that time?arrow_forwardPart c) Not using excel!arrow_forwardJefferson Bank made a loan at 7% interest for 238 days. If the amount of interest was $300.81, use the ordinary interest method to find the amount of principal (in $) borrowed. (Round your answer to the nearest dollar.) Need Help? Read It Watch It Master Itarrow_forward
- Need hood explanation, don’t use excel please. Tsinoor takes out a loan of $6800. He will repay the loan over 5-years with semi-annual payments of $816 (first payment due in 6-months). Using linear interpolation, what rate of interest, j2 is being charged on the loan?arrow_forwardUse Excel to calculate the total interest on a $896,861 loan for a small business making monthly payments with an interest rate of 4% over 30 years. Round your answer to the nearest hundredth. Enter your answer as a positive number.arrow_forwardPlease solve this questionarrow_forward
- Please don't provide handwritten solution ....arrow_forwardA borrower has two alternatives for a loan: (1) issue a $570,000, 90-day, 7% note or (2) issue a $570,000, 90-day note that the creditor discounts at 7%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet a. Compute the amount of the interest expense for each option. Round your answer to the nearest dollar. for each alternative. b. Determine the proceeds received by the borrower in each situation. Round your answers to the nearest dollar. (1) $570,000, 90-day, 7% interest-bearing note: $ (2) $570,000, 90-day note discounted at 7%: $ c. Alternative is more favorable to the borrower because the borrowerarrow_forwardTyping onlyarrow_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