Calculate totals for cash payments

Assignment Help Cost Accounting
Reference no: EM13495368

On January 1, 2013, Bainbridge Company borrowed $100,000 cash from a bank by issuing a 10-year, 9 percent note. The principal and interest are to be paid by making annual payments in the amount of $15,582. Payments are to be made December 31 of each year beginning December 31, 2013.

1. Set up the spreadsheet as shown below. Notice that Excel can be set up to calculate the loan payment. If you're unfamiliar with this, see the following Spreadsheet Tips section. The Beginning Principal Balance (B12) and Cash Payment (C12) can be referenced from the Loan Information section. The interest rate used to calculate Interest Expense (D12) can also be referenced from the Loan Information section.

2. Complete the spreadsheet for the 10 periods.

3. In Row 23, calculate totals for cash payments, interest expense, and applied to principal.

4. Consider how the amounts would differ if Bainbridge were to borrow the $100,000 at different interest rates and time periods. The results of the original data (option 1) have been entered in the following schedule. In the spreadsheet, delete 9 percent and 10 from cells B4 and B5, respectively. Enter the data for the second option (8 percent and 10 years) in cells B4 and B5. Enter the recomputed payment and total interest in the schedule for the second option. Continue the same process for options 3 through 9 by deleting the prior rate and number of periods in the spreadsheet and entering in the next option's data. The number of years scheduled (rows 12 through 21) will have to be shortened for the 7-year options and lengthened for the 13-year options.

Reference no: EM13495368

Questions Cloud

Expalin reaction before the equivalence point : a.)100 mL of 1.00 M HCl solution is titrated with 1.00 M NaOH solution. You added the following quantities of 1.00 M NaOH to the reaction flask. Classify the following conditions based on whether they are before the equivalence point
Determine changes in composition of a fluid : What information has to be obtained in order to ensure that the method will be a satisfactory one and determine changes in composition of a fluid. Define what is meant by refractive index, and give the relationship between the incident and refracte..
What is the speed and direction of the first cart : A 0.35 kg cart traveling at 0.6 m/s to the right collides with a stationary 0.55 kg cart. After the collision the second cart (.55kg) is traveling to the right at 0.32 m/s, What is the speed and direction of the first(.35kg) cart
Explain a is pass through a sn(no3)2 solution : A current of 3.68 A is pass through a Sn(NO3)2 solution. How long (in hours) would this current have to be applied to plate out 8.20 g of tin
Calculate totals for cash payments : Consider how the amounts would differ if Bainbridge were to borrow the $100,000 at different interest rates and time periods. The results of the original data (option 1) have been entered in the following schedule. In the spreadsheet.
What is the speed of sound in neon gas : A speaker and two microphones are arranged inside a sealed container filled with neon gas. What is the speed of sound in neon gas
What is the initial velocity of the green car : A red car and a green car, identical except for the color, move toward each other in adjacent lanes and parallel to an x axis. What is the initial velocity of the green car
Determine the average value of the material : How often would the sample have to be taken - If the objective was to determine the average value of the material in the bunker, how could this be done by making one measurement?
Define how much nickel is plated out of the solution : A current of 3.65 A is passed through a Ni(NO3)2 solution for 1.80 hours. How much nickel is plated out of the solution

Reviews

Write a Review

Cost Accounting Questions & Answers

  On 31st december 2010 the south padre company had a

on 31st december 2010 the south padre company had a deferred tax liability balance of 8100 starting from an excess of

  On 1 july 2010 cherry ltd acquired an item of plant for

on 1 july 2010 cherry ltd acquired an item of plant for 31864. on the same date cherry ltd entered into a lease

  Compute submarines eps for the year

Submarine, Corp., earned net income of $110,000 for 2011. Submarine's books include the following figures: Preferred stock, 2%, $30 par, 1,000 shares issued and outstanding   $30,000 Common stock, $1 par, $52,000 issued   $52,000 Paid-in capital in e..

  How much did the company allocate for manufacturing

The Super Supply Company manufactures cleaning spray for public schools. During 2012, the company spent $680,000 on prime costs and $540,000 on conversion costs. Overhead is applied at a rate of 150% of direct labor costs.

  Consider each finished unit we produce requires the

consider each finished unit we produce requires the subsequent two direct materials1. 500 pounds of direct material a

  Lakeway enterprisesregression analysis casegeorganna

lakeway enterprisesregression analysis casegeorganna russell the controller of lakeway enterprises a fabricator

  Estimate the required balance of the allowance

Estimate the required balance of the Allowance for Doubtful Accounts at December 31, 2011, using the aging of accounts receivable method.

  Q1the high-low method uses cost and activity data from just

q1.the high-low method uses cost and activity data from just two periods to establish a cost formula.a.

  Would the company be better off using direct labor cost

Harris, Inc., has just completed job nos. 78 and 79, which were similar in terms of complexity, production processes, and units manufactured. Job no. 78 was manufactured by Joe Barton who earns $14 per hour, whereas job no. 79 was completed by Sus..

  Dq 01explain how full-absorption costing can be abused by

dq 01explain how full-absorption costing can be abused by management to misstate financial results.dq 02explain how cvp

  Find who are stakeholders in this situation

Find who are stakeholders in this situation and Explain what are Curtis's ethical obligations to the corporation? and to his friend ?

  After researching the different forms of business

after researching the different forms of business organization mariam decides to operate cookie creations as a

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd