Reference no: EM131785388
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.
|
Illustrate effects on the accounts and financial statement
: Illustrate the effects on the accounts and financial statements of Milan Co. to record (a) the purchase, (b) the merchandise return, and (c) the payment.
|
|
Define bond selling at a discount or at a premium
: Suppose that a 10-year corporate bond has a maturity value of $10,000 and a coupon rate of 10%, with coupons paid semiannually.
|
|
Disparities that arise in one’s cognitive accounting
: how might you frame certain decisions to benefit from the disparities that arise in one’s cognitive accounting?
|
|
What is ted gross profit for march
: During March, two cars are sold for $9,000 each. Ted determines that at March 31, the $9,750 car is still on hand. What is Ted's gross profit for March
|
|
Create each table on a separate worksheet
: For the excel assignment, I would like for you to complete two amortization tables. Create each table on a separate worksheet (not file).
|
|
Discuss additional information you need to make decision
: the financial statements are fairly presented. On the last day of the examination, you discover that one of your supervisors assigned
|
|
Discussing hip-hop performers
: The term “authentic” is used frequently when discussing hip-hop performers. Discuss your opinion of what you think term “authentic” means in context of music.
|
|
Which payment method costs less
: If you took a home mortgage loan of $150,000 for 30 years at 8.4%, compounded monthly, your monthly payments would be $1142.76.
|
|
Calculate the cost of the inventory at january
: Kershaw Bookstore had 500 units on hand at January 1, costing $18 each. The cost of the inventory at January 31, under the FIFO method is
|