Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please do this question fast On February 1, 2014 X-cell Inc. borrowed $1,056,000 by signing a five-year installment note bearing interest at 9%. Complete the

image text in transcribed

please do this question fast

On February 1, 2014 X-cell Inc. borrowed $1,056,000 by signing a five-year installment note bearing interest at 9%. Complete the installment note amortization schedule for this note assuming each payment requires equal total payments. Use the built-in PV functions for these calculations. Enter PV(n;i) in a value box to calculate the present value of $1 over n compounding periods with a periodic rate of i. Similarly, use PVA(n;i) to calculate the present value of an annuity. E.g., the present value of $1,000 with a periodic rate of 3%, and 2 compounding periods can be entered as 1000+PV(2:3). To use the built-in PV functions to calculate the payment, the formula is: Principal balance + PVA(n;i), where n = the number of payments and i = the interest rate. For example, if $10,000 is borrowed by signing a four-year, 5% installment note. The note requires four equal payments of accrued interest and principal. Each of the four equal payments is calculated by entering the following in the value box: 10000 / PVA(4;5), which equals payments of $2,820. Equal Total Payments Table Period Ending Beginning Balance Periodic Interest Expense Reduction of Notes Payable Total Notes Payment Ending Balance January 31, 2015 January 31, 2016 January 31, 2017 January 31, 2018 January 31, 2019 Total

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Progressive Audit A Toolkit For Improving Your Organizational Quality Culture

Authors: Robert Pfannerstill

1st Edition

0873896629, 978-0873896627

More Books

Students also viewed these Accounting questions

Question

Between 1% to 3% of infants and toddlers meet criteria for GDD.

Answered: 1 week ago

Question

1. Identify three communication approaches to identity.

Answered: 1 week ago

Question

d. Who are important leaders and heroes of the group?

Answered: 1 week ago

Question

3. Describe phases of minority identity development.

Answered: 1 week ago