Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. create an amortization schedule in excel that can

Create an amortization schedule in excel that can project a 360 month self liquidating mortgage...

80.2K

Verified Solution

Question

Accounting

Create an amortization schedule in excel that can project a 360 month self liquidating mortgage including balance, payment, interest and principal payment. Column headings are period, beginning balance, payment, interest, principal, ending balance. I believe you know how to calculate payments, interest is prior balance x interest rate /12 and principal is payment - interest. As payments are applied the loan pays down to zero with the last payment. Please create this spreadsheet so that the loan amount and interest rate may be adjusted.

No numbers were given

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Mary has a limited food budget, but still wants to make sure her family members meet...

Advance Math
Q

Ethical and legal standards are important because they:a. guarantee clients receive safe, quality careb. provide...

Biology
Q

Lab Data K Volume 02 mL Time min Tube 1 Green Light Tube 2 Green...

Biology
Q

A conducting sphere of radius r having charge Qo is connected to earth through an...

Physics
Q

How much material would be needed for the rungs of a ladder of 30 rungs,...

Basic Math
Q

what are current liabilities? What are some examples of current liabilities? when does a company...

Accounting
Q

At the beginning of 2012, D & L Enterprises had the following balances in its...

Accounting
Q

An artist is planning to sell signed prints of her latest work. If 30 prints...

Accounting
Q

the dadds lamp company dlc owned by josie dadds. is a wholesale company that purchases...

Accounting
Q

Yasser has just won the Quebec Lottery with a jackpot of $1,000,000. His winnings will...

Finance
Q

residential rental real estate is classified as what kind of property? section 1245, section 1250

Accounting
Q

You have just been appointed an Assistant Project Manager for a business entity 3Rogers Inc....

Accounting