Question: 1. (596) Develop a general-purpose Excel spreadsheet to calculate the balance due, principal payment, and interest payment for each period of a loan. The user

1. (596) Develop a general-purpose Excel

1. (596) Develop a general-purpose Excel spreadsheet to calculate the balance due, principal payment, and interest payment for each period of a loan. The user inputs to the spreadsheet will be the loan amount, the number of payments per year, the number of years' payments are made, and the nominal interest rate. Make the fallowing analysis in a separate Excels sheets. a. (596) Loan in the amount of $23,463 at 9.34% APR over 36,48 and 60 months. i) What is the total interest paid for each number of payments. ii) Compare the options and discuss pros and cons for each option. b, (5%) Loan in the amount of $189,500 at 4.9% APR over 15,20 and 30 years. i) What is the total interest paid for each number of payments. iv) Compare the options and discuss pros and cons for each option

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Develop a general-purpose Excel spreadsheet to calculate the balance due, principal payment, and interest payment for each period of a loan. The user inputs to the spreadsheet will be the loan...

(6%) Develop a general-purpose Excel spreadsheet to calculate and show, the balance due, principal payment, and interest payment for each period of a loan. The user inputs to the spreadsheet will be...

i need help plugging in the random list of notes into the excel Balance sheet schedule. Schedule 1: Machinery and Equipment See "Schedule 1: Machinery' on "Financial Statement & Analysis Help Tabs"...

Objective: The purpose of this assignment is to let you see the complexity of budgeting and to develop your spreadsheet skills. Case: Campanile Caf is a small, local business that sells hot coffee...

sted Income Statement Student Copy-1.xlsx Download Page > of 5 ZC Tractor and Machinery Useful life Salvage Value Cost Value 10 years $ 75,000.00 $200,000 Annual Depreciation 12500 Year Book Value...

im not sure what number to use for the equal payment amount or how it is supposed to be set up if you could do one so i have an example to go off that would be great 1 2 BTW- A ES a 3 Merge Center...

Please answer all question. Thank you Develop an amortization spreadsheet. The following inputs should be provided in the spreadsheet Annual interest rate Loan term (in years) Payments per year Loan...

Need assistance with this case study for Corporate tax class Davidson Company - Initial Input Variables (2013 Tax Year): Initial Year 1 Business Incomes: Sales Revenues Consulting Fees Business...

This assignment provides a good example of using Excel to develop a cash budget.An Excel spreadsheet to calculate answers to questions related to Salt Lake Light Opera in Problem 7-43 on pages...

1. (5 points, 5 *1 ) a. According to the rule of 72, how many times your money will be doubled over a 36 - year period if it earns a rate of return of 8% per year? Show your work. b. Usi ng the rule...

On January 1, 2025, Blue Company purchased 12% bonds having a maturity value of $325,000 for $349,639.81. The bonds provide the bondholders with a 10% yield. They are dated January 1, 2025, and...

You are deciding between two mutually exclusive investment projects. Both require the same upfront investment of $9.8 million. Investment A will generate $2 million per year in perpetuity (starting...

Please help solve if the answers are correct and how to get the value of tax shield and value of operations: Merger analysis - Adjusted present value ( APV ) approach Eades Logistics Corp., which is...

A particle is moving in three dimensions and its position vector is given by; r(t) = (4, 4t + 2, 3t)i + (4, 5t - 2, 3)2 + (3, 3t + 3, 1t)k where r is in meters and t is in seconds. Determine the...