Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

Accounting


Home >> Accounting Basics

Assignment

For the excel assignment, I would like for you to complete two amortization tables.

Follow these instructions (meant to make sure you can use excel).

Create each table on a separate worksheet (not file).

Name the worksheets Discount and Premium

Assume the following for the bond:

1. 10 year term
2. bond payments happen semi-annually
3. Principal amount of bond is 10,000,000;
4. Stated rate on the bond is 8%
5. Market rate of interest is 6% for one table and 10 % for the other (name the worksheets appropriately) Note that the two worksheets will have identical formulas if you use excel to its full power.

The first 5 lines of the worksheet should have the following information with labels in column A and the numerical value (or formula to calculate the numerical value in column B.

Number of payments
Principal amount
Stated Rate of Interest
Market rate of interest

Semi-annual payment (use a formula to calculate this referencing other cells)

The sixth line of the worksheet should have calculation of the present value of the bond. Hint: use the "PV function"

Lines 8-27 should include the amortization table. The table shall contain 5 columns.

Col 1: Beginning Book Value
Col 2: Interest Expense
Col 3: Cash flow or payment
Col 4: Reduction in Principal
Col 5: Ending book value.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M92594070
  • Price:- $15

Priced at Now at $15, Verified Solution

Have any Question?


Related Questions in Accounting Basics

Questions - q1 conner corporations adjusted trial balance

Questions - Q1. Conner Corporation's adjusted trial balance included the following items:Accounts payable ($65,000), Accounts receivable ($45,000), Capital stock ($100,000), Cash ($50,000), Dividends ($10,000), Goodwill ...

Question - the samuel company uses the straight-line method

Question - The Samuel Company uses the straight-line method to depreciate its equipment. On May 1, 2014, the company purchased some equipment for $224,000. The equipment is estimated to have a useful life of ten years an ...

Question - watch the video then discuss the differences

Question - Watch the video then discuss the differences between variable and absorption costing. How does variable costing help a company make good management decisions? List some examples of ways in which a business wou ...

Question - during 2017 crimson inc purchased 2775000 of

Question - During 2017, Crimson Inc. purchased $2,775,000 of inventory. The cost of goods sold for 2017 was $2,635,938 and the ending inventory at December 31, 2017 was $544,688. What was the inventory turnover for 2017?

Question -a explain the terms absorption costing and

Question - (a) Explain the terms Absorption Costing and Variable (Direct) Costing. (b) How does Variable (Direct) Costing differ from Absorption Costing? (c) What is the difference between Expired Costs and Unexpired Cos ...

Question - why is net income before tax the most common

Question - Why is net income before tax the most common base used to determine the preliminary judgment about materiality? In what circumstances might the auditor use a different base?

Question - the following list of accounts appear in

Question - The following list of accounts appear in alphabetical order and were taken from ABC Corporation's ledger as of December 31, 2018. The Accounts Payable records were missing. Accounts Payable $? Inventory $7,000 ...

Question assume you have just been hired as the chief human

Question: Assume you have just been hired as the Chief Human Resources Officer (CHRO) for any Fortune 500 company of your choice (must be a different company than was employed for your Team Application, Reflection, and S ...

Question - the following information relates to nebula

Question - The following information relates to Nebula, Inc. Sales Revenue $240,000 Cost of Goods Sold 160,000 Interest Revenue 10,000 Operating Expenses 40,000 Sales Discounts 20,000 Sales Returns and Allowances 7,000 C ...

Question - havel and petra are married will file a joint

Question - Havel and Petra are married, will file a joint tax return, and meet the requirements to file form 1040EZ. Havel has w-2 income of $40,000 and Petra has w-2 income of $44,542. Use the appropriate Tax Tables and ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved