Calculate interest in a spreadsheet the number

Reference no: EM131079390

Debt Restructuring

Scofield Enterprises has a customer who purchased a software system for $10,000 and arranged to pay for the system over 60 months in an equal payment note. The owner of Scofield Enterprises sat down with your boss this week when she realized that the customer wasn't going to make his next payment. Their conversation is available atACCT 3310 Professional Application: Part 2provided below in this folder.

REQUIRED:

Download theProject 2 Spreadsheetand customize your project by entering your phone number on the Start Here worksheet.
Listen to and watch the conversation between the accountant and the owner atACCT 3310 - Professional Application: Part 2.
Use the information on theOriginal Debt Contractworksheet in theProject 2 Spreadsheetplus the information you gather from the owner / accountant's discussion to develop an amortization for the original debt contract. You should pay particular attention to the following issues

When you calculate interest in a spreadsheet the number is accurate to fractions of a penny, but customers can only pay in pennies. Round the interest you calculate to the higher penny (to the advantage of your client) using the appropriate EXCEL function.
Because interest and payment are both rounded numbers, the amortization table will not work out exactly to a final principal of 0. The final payment should be adjusted to exactly the amount needed to pay off the debt.

Then restructure the debt contract to lower the monthly payment. You should identify the features that you have changed between the original debt contract and then new debt contract and create a new amortization table based on the new principal, the new term of the debt, and the new interest rate. Use the EXCEL functionPMTto find the payment for your restructured debt contract. You will need to round interest payments to the next penny and set the final payment to exactly pay off the debt, as you did in (3) above.
GAAP requires that the lender record the value of the note on its books at the present value of the payments using the original interest rate (even if the interest rate is changed in the restructuring). Calculate the GAAP value of the restructured note.
Calculate the loss on note restructuring as the difference between the carrying value of note immediately before restructuring and the value you calculated in (5).
Prepare a memorandum in a separate WORD file to the owner that

presents your recommended restructuring of the debt, supporting the changes you are making
explains the amortization table of the restructured note and the loss on note restructuring.

NOTE: Each piece of numerical information should be entered into the workbook just once. You should use cell addresses in all subsequent formulas -- even to bring information from one worksheet to the next. Your workbook should be sufficiently integrated that a change to the number in the new debt contract will flow through to the final amortization table without your having to make any additional adjustments

Reference no: EM131079390

Questions Cloud

Social and behavioral intelligence in your field : It is important to your professional image to know how to communicate verbally and physically. Imagine speaking to a person who is standing too close to you. This may make you feel uncomfortable because your personal space is infringed upon.

Explain the governing board role in strategic initiatives : In both monetary and process terms, describe the costs and benefits associated with implementing EMR and associated health data systems.

Analyze multiple variables : Go to the American Federation of Teachers website and search for the most recent data on "teacher salaries" and find the state of Idaho. Compare the teacher salaries in your state to teacher salaries in 3 other states and to teacher salaries in t..

Calculations according to methods of NPV-IRR-Payback Period : Please make decision on whether to invest in project A, if required rate of return is 10%? Please base your decision on the calculations according to the methods of NPV, IRR, Payback Period, etc.

Calculate interest in a spreadsheet the number : Scofield Enterprises has a customer who purchased a software system for $10,000 and arranged to pay for the system over 60 months in an equal payment note. The owner of Scofield Enterprises sat down with your boss this week when she realized that ..

Country of origin of aegon : What is the country of origin of Aegon which has a tie up with Religare in India for Insurance?

Criticism nor apology for the president : Please do not get into the polar BS that seems to surround any intelligent discourse about the efficacy of our Federal government and elected officials. Instead, look more closely at the tools for managerial control and the incredible constraints ..

Determine which state board of education actually preferable : Consider this assignment as though you were reviewing several job offers from different states. How would you determine which state board of education was actually preferable? What things would you consider in making your choice?

How much must the firm borrow to achieve target debt ratio : Beranek Corp has $720,000 of assets (which equal total invested capital), and it uses no debt—it is financed only with common equity. The new CFO wants to employ enough debt to raise the total debt to total capital ratio to 40%, using the proceeds fr..

User Account

All Pages