Fill in order details

  • Submit your instructions
    to writers for free!

Chat with the writer

  • Chat with preferred expert writers
  • Request a preview of your paper
    from them for free

Editing

  • Project edited by the quality evaluation department

Download Your Completed Project

  • Download the completed project from your account or have it sent to your email address

In order to expand, El Cap Climbing Company (ECCC) is considering taking out a mortgage for a new store location, a nonresidential real property that includes land and a building. Leah is unsure if she has the cash flow to take on any more debt. She asked you to create a loan amortization schedule for the proposed mortgage loan.

In order to expand, El Cap Climbing Company (ECCC) is considering taking out a mortgage for a new store location, a nonresidential real property that includes land and a building. Leah is unsure if she has the cash flow to take on any more debt. She asked you
to create a loan amortization schedule for the proposed mortgage loan. Then, you’ll create a chart that represents the portion of each payment that goes toward principal and interest.

A. Prepare the following:

  • A loan amortization schedule
  • A chart showing the percentage of the payment applied toward the principal and interest

Loan Amortization Schedule

First, you’ll need to create a loan amortization schedule in the downloaded Excel spreadsheet. Create the table on the tab named “Part 2 Loan Amortization Sched.” The following table illustrates the payments and interest amounts for a fixed-rate, 30-year, $500,000 mortgage, at a five-percent interest rate. The monthly payment will be 2,684.11.

The table serves as an example of what you’ll create in Excel. Note that the table shows only the figures for the first and the last year of payments; you’ll need to calculate the amounts for the remaining payments, and fill them in.
Once you’ve determined how each of the amounts in the table is obtained, you can use relative and absolute cell references to fill in the full 360 payments.

The following is an explanation of the columns in the table:

  • Payment number—The first column in the table shows the 360 payments required to pay off the mortgage loan (30 years, with 12 monthly payments per year).
  • Payment amount—The second column shows the monthly payment amount.
  • Interest—The third column shows the portion of the monthly payment that goes to interest.
  • Principal—The fourth column shows the portion paid toward the principal.
  • Balance—The fifth column shows the starting balance of $500,000, and the remaining balance each month after the principal is subtracted.
  • Annual interest expense—The last column provides a running total of the interest expense on the mortgage for the entire 12-month period. It’s the amount that would be reported on the financial statements.
  • Totals—The “Totals” under the “5% Interest Expense” and “Principal” columns show the final totals for the 30-year life of the mortgage.

Mortgage Principal and Interest Chart

Next, you’ll create a chart following these steps. Create the table on the tab named
“Part 2 Chart.”

1. Start by selecting the Interest Expense and Principal columns. Make sure to select the column headers and values. Don’t select the Totals row.
2. Click on the Insert tab and select a “Stacked Column.” Make sure to label the x-axis (payment month) and y-axis (dollars), and include a legend for the two values (interest and principal).
3. Your final chart should be set up similar to the chart below, with the data populating the chart. (The increments don’t need to be the same).

B. Answer the following:

1. How can you describe the relationship between time and the amount paid towards principal and interest?
2. Knowing what we know about ECCC’s cash flow from Part 1, is it reasonable to believe that ECCC can take on this new debt?

Place your order now on a similar paper and get best quality work written by our expert level writers. “A” guaranteed.assignment writing help

What our customers say
_____

Ishita M.Ishita M.
Great Job! Thank you so much for your work. You got it done faster than I imagined and everything is perfect. Will definitely be using you again!
Megan J.Megan J.
"As a wife, mother, and full-time student, I was struggling to try to go back to school and take care of my responsibilities. Sometimes you just need a little help, and I appreciate all the help I have gotten from Academic Research Bureau. My papers are on-time and the writers are easy to work with. Thanks for the support!"
Rajab M.Rajab M.
Universitywritingservices.com has saved me a lot of time. I was tired of taking the same classes many times over again. As an ESL student, my professors were taking points off of my assignments for my grammar mistakes. It made it very hard to feel encouraged to continue with my studies. Thankful for having found an answer for better grades."
Frank N.Frank N.
As a working student, I just really don't have the time to write paper after paper and complete assignment after assignment. Working full-time and going to school was nearly impossible until I was able to feel comfortable with the writers on this site. They make me feel secure enough to trust them with my papers. While I'm busy with life, they are busy writing my papers. They always do an outstanding job!
Courtney B.Courtney B.
Thank you! You were really patient with me and my needs. This was my first time using you guys, however, I will definitely be using you again!
John H.John H.
I cannot tell you enough how amazing your company is! Your writers are superb, on time, excellent content, so very thankful you reached out to me that day! Lifesaver for sure! Couldn’t be happier with the results I’ve gotten from my first 2 papers with you, I have 4 papers left to go and I’ll be using your company for them all!
Rebecca T.Rebecca T.
After I ordered a dissertation from your writing service, the first paper that I was given did not met my professor’s demand. I set the paper on revision and the writer made the revision for free meeting all my requirements and I was very satisfied
Thomas R.Thomas R.
I was shocked by how your writers managed to deliver my paper on time, and I was among the best in our class in that paper. Thank you so much and I will never hesitate to use you
error: protected!!