Beginning Book Value In Amortization Table

December 6, 2022

Beginning Book Value In Amortization Table

Order Number	636738393092
Type of Project	ESSAY
Writer Level	PHD VERIFIED
Format	APA
Academic Sources	10
Page Count	3-12 PAGES

Instructions/Descriptions

Beginning Book Value In Amortization Table

[Order Now]

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:

10 year term

bond payments happen semi-annually

Principal amount of bond is 10,000,000;

Stated rate on the bond is 8%

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 Beginning Book Value in 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

[Order Now]

There should be nothing in the worksheet except formulas which will reference back to one of the calculations or inputs in rows 1-6. For example, your calculation of interest expense in the table will be a formula that references back to the cell address where you entered principal amount and the relevant interest rate. Using an “absolute reference” will make this easier for some of the work. Look that up in the help function if you don’t know what that means.

I will grade this by changing any value in rows 1-5. To get full credit, the entire worksheet should update accurately using the new values input in rows 1-5. Thus, the worksheet should work for any value in rows 1-5.

Your last row, last column should equal to zero if you have done the table correctly.

Beginning Book Value In Amortization Table

RUBRIC

Excellent Quality

95-100%

Introduction

45-41 points

The context and relevance of the issue, as well as a clear description of the study aim, are presented. The history of searches is discussed.

Literature Support

91-84 points

The context and relevance of the issue, as well as a clear description of the study aim, are presented. The history of searches is discussed.

Methodology

58-53 points

With titles for each slide as well as bulleted sections to group relevant information as required, the content is well-organized. Excellent use of typeface, color, images, effects, and so on to improve readability and presenting content. The minimum length criterion of 10 slides/pages is reached.

Average Score

50-85%

40-38 points

More depth/information is required for the context and importance, otherwise the study detail will be unclear. There is no search history information supplied.

83-76 points

There is a review of important theoretical literature, however there is limited integration of research into problem-related ideas. The review is just partly focused and arranged. There is research that both supports and opposes. A summary of the material given is provided. The conclusion may or may not include a biblical integration.

52-49 points

The content is somewhat ordered, but there is no discernible organization. The use of typeface, color, graphics, effects, and so on may sometimes distract from the presenting substance. It is possible that the length criteria will not be reached.

Poor Quality

0-45%

37-1 points

The context and/or importance are lacking. There is no search history information supplied.

75-1 points

There has been an examination of relevant theoretical literature, but still no research concerning problem-related concepts has been synthesized. The review is just somewhat focused and organized. The provided overview of content does not include any supporting or opposing research. The conclusion has no scriptural references.

48-1 points

There is no logical or apparent organizational structure. There is no discernible logical sequence. The use of typeface, color, graphics, effects, and so on often detracts from the presenting substance. It is possible that the length criteria will not be reached.