Question: On my loan Amortization Schedule I need the Excel Formula to find the three remaining fields labeled Current Portion Principle, Non-Current and Annual Interest Expense

On my loan Amortization Schedule I need the Excel Formula to find the three remaining fields labeled "Current Portion Principle", "Non-Current" and "Annual Interest Expense"

<http://lessons.pennfoster.com/pdf/060952.pdf#page=132> --Link to Assignment Details

<https://docs.google.com/spreadsheets/d/1uUPAxCx03crthOktFSDiHM-hva61OZFLJZLjYoK4AV8/edit#gid=0> ---- Link to my Table

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 Finance Questions!

Consider the closed-loop system in Figure E4.11, where G(s) = K / s + 10 and H(s) = 14 / s2 + 5s + 6 (a) Compute the transfer function T(s) = Y(s)/R(s). (b) Define the tracking error to be E(s) =...

In this project, youll create a loan amortization schedule for an example mortgage loan. Imagine the mortgage is for a nonresidential real property your company has purchased. The property includes...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

FIN310 Graded Project: Corporate Finance Your project must be submitted as an Excel document. Your project will be individually graded by your instructor and, therefore, will take up to a few weeks...

I have posted this question before but no one seems to complete it. I need the Current and Non Current columns. I have all of the other information You'll need to create an amortization schedule. The...

PLEASE HELP ME!! I can't figure out these answers Prepare a horizontal analysis of the Income Statement for the most current year. (See page 18-11 for the proper format). Note you MUST USE EXCEL to...

Dr.Ramsey Please assist me with my discussion post. Subject: Annuities Systematic risk evaluates the probability and extent of negative consequences to the larger body. For example, the government...

Working on a final paper evaluating General Motors Co, corporate performance. Attached is the outline of the assignment along with GM financial annual statement. Evaluation of Corporate Performance...

The questions are attached. All worksheets should be complied within one Excel workbook. Thank you. Rosey's Roses Inventory Type Shrub Shrub Shrub Shrub Shrub Shrub Shrub Shrub Climber Climber Tree...

(a) Write down the incidence matrix A for the indicated digraph. (b) What is the rank of .4? (c) Determine the dimensions of its four fundamental subspaces. (d) Find a basis for its kernel and...

If x R, x > 0, and if r, s Q, show that xrxs = xrs = xsxr and (xr)s = xrs = (xs)r.

Under ideal conditions a certain bacteria population is known to double every 2 hours. Suppose there are initially 4 0 0 bacteria. What is the size of the population after 6 hours? Answer: 2 . What...

Presented below is an incomplete balance sheet for Main River Corp. Additional information: 1. Assume average balances equal ending balances for the purpose of this exercise. 2. The receivables...

1. List some of the complexities in vehicle buying, and offer your advice on how to get a best buy. 2. What three aspects of a vehicle purchase should be negotiated? In what order? 3. Why should you...

(a) What advice might Maria give Teresa about managing her student loan debt? (b) If next year Teresa were to consolidate her loans into one loan at 6percent interest, what advice might Maria give...

1. Explain why it is difficult for many people in relationship to talk about money matters. 2. Identify four ways you could more effectively communications about money matters. 3. List four things...

1. Distinguish among credit cards, debit cards, and a store-value card. 2. List the steps you should take if you find an error in your periodic statement regarding an electronic transaction. 3....

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Zero-Coupon Bonds Coal Corporation is considering alternatives to provide funding for the future expansion of its mining activities. Management is concerned, however, that the company might have...

Bond Issued at Discount On January 1, 2002, Albany Corporation receives $438,000 when it issues bonds with a par value of $450,000 and a stated interest rate of 7 percent. The bonds mature on...

Bond Issued at Premium Gigantic Enterprises issues bonds with a par value of $700,000 on January 1, 2001, and receives $724,000. The stated interest rate on the bonds is 10 percent and interest is...