Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Refer to the information in S10-7 and prepare a worksheet that uses formulas to reproduce the effective-interest bond discount amortization schedule shown in Chapter Supplement 10B. Display both the completed spreadsheet and a formulas revealed (Ctrl ~) version of it. Info S010-7 Assume the authors of a popular introductory accounting text have hired you to create spreadsheets that will calculate bond discount amortization schedules like those shown in this chapter. As usual, you e-mail your friend Owen for some guidance. Much to your disappointment, you receive an auto-reply message from Owen indicating that hes gone skiing in New Zealand. After a bit of panicking, you realize you can refer to Owens previous e-mail messages for spreadsheet advice that will help you complete this task. From his advice for Chapter 9, you decide to create a data input section for the stated interest rate, market interest rate, face value, issue price, and years to maturity. The spreadsheet file also will have a separate amortization schedule worksheet that contains only formulas, references to the cells in the data input section, and references to other cells in the amortization schedule. All amounts will be rounded to the nearest dollar (using the Round function in Excel), which means the discount amortization in the final year might be off a few dollars (unless you use the IF function in Excel to eliminate any remaining discount in the final year of the bonds life, in the same way that Owen showed in Chapter 9 for declining-balance depreciation).
Required:
Prepare a worksheet that uses formulas to reproduce the straight-line bond discount amortization schedule shown in Chapter Supplement 10 A. Display both the completed spreadsheet and a formulas revealed (Ctrl ~) version of it.
A machine cost $500,000 on April 1, 2010. Its estimated salvage value is $50,000 and its expected life is eight years. Calculate the depreciation expense (to the nearest dollar) by each of the following methods, showing the figures used.
Finley Corporation had income from continuing operations
during 2009 the ellis corporation had 370000 shares of 20 par common stock outstanding. on january 1 2009 2000 8
you are doing a review services and related tax work engagement for murphy construction company. you have made
from the account balances listed below prepare a schedule of cost of goods manufactured for sampson manufacturing
Many companies hold equity securities of other companies as investments. The journal entries and accounting methods differ, depending on the percentage of interest held. Discuss briefly the various categories of these investments and why the accou..
benson and orton are partners who share income in the ratio of 23 and have capital balances of 60000 and 40000
prepare a three-page memo at least 300 words per page to john and jane smith addressing the issues presented1. john
bampv enterprises exchanged a used crane with an original cost of 200000 and accumulated depreciation of 140000 for a
poc company accounts for a long-term construction contract using percentage - of - completion method . as of the end of
How may financial managers budget for unforeseen changes and improvemeHow may financial managers budget for unforeseen changes and improvements in information technology that require large capital outlays?
The tractor-trailer would be used in the company's hauling business, resulting in additional net cash inflows of $24,000 per year. The internal rate of return on the investment in the tractor-trailer is closest to:
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd