Danno Company issued $700,000, 8% bonds payable on January 1, 2023. The bonds mature in four...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Danno Company issued $700,000, 8% bonds payable on January 1, 2023. The bonds mature in four years on January 1, 2027 and pay interest semi-annually on June 30th and December 31st. Danno's fiscal year ends October 31st. On January 1, 2023, the market rate of interest for similarly risky investments was 7%. Danno retired 30% of the bond issue on January 1, 2025 by purchasing bonds in the open market. The market rate of interest on January 1, 2025 was 6%. This problem requires the use of the Excel spreadsheet template provided to compute answers to the questions. Present all numbers as whole numbers (i.e. no decimal places). Below is a list of the cells in which you will input numbers (cells are highlighted in yellow). Remaining cells should use formulas or references to other cells. ● Cell D4-face value of bonds Cell E4 relevant PV factor from textbook for Question 1 Cell E5-relevant PV factor from textbook for Question 1 Cell C11 - the semi-annual cash interest rate Cell D11 the semi-annual market interest rate Cell F59- the relevant PV factor from textbook for Question 4 Cell F60- the relevant PV factor from textbook for Question 4 1) 2) 3) 4) 5) 6) ● ● ● Complete the chart to compute the issue (selling) price of the bonds on January 1, 2023. (1 point) Prepare an amortization schedule for the life of the bond issue. If done correctly, final book value should be within $1-$2 of $700,000 (due to rounding in the PV tables) (3 points) Prepare journal entries for the dates indicated. Type account titles, use cell references for debit and credit amounts. You do not need to indent account title credits as long as the numerical amounts are in the correct (debit or credit) column. Be sure credits come after all debits in a given entry. Also- no entries can contain negative numbers (i.e. a negative credit indicates the account should be debited and vice versa). (3 points) Compute the bonds' market value on January 1, 2025 (for cell E56, use cell reference D4, rather than $700,000 so the question recomputes when the original issue price is changed). (1 point) Prepare the entry to retire 30% of the bonds on January 1, 2025. (2 points) Working spreadsheet - when grading the spreadsheet, I will replace the $700,000 face value of the bonds in cell D4 with $800,000 and verify the spreadsheet correctly recalculates amounts. Danno Company issued $700,000, 8% bonds payable on January 1, 2023. The bonds mature in four years on January 1, 2027 and pay interest semi-annually on June 30th and December 31st. Danno's fiscal year ends October 31st. On January 1, 2023, the market rate of interest for similarly risky investments was 7%. Danno retired 30% of the bond issue on January 1, 2025 by purchasing bonds in the open market. The market rate of interest on January 1, 2025 was 6%. This problem requires the use of the Excel spreadsheet template provided to compute answers to the questions. Present all numbers as whole numbers (i.e. no decimal places). Below is a list of the cells in which you will input numbers (cells are highlighted in yellow). Remaining cells should use formulas or references to other cells. ● Cell D4-face value of bonds Cell E4 relevant PV factor from textbook for Question 1 Cell E5-relevant PV factor from textbook for Question 1 Cell C11 - the semi-annual cash interest rate Cell D11 the semi-annual market interest rate Cell F59- the relevant PV factor from textbook for Question 4 Cell F60- the relevant PV factor from textbook for Question 4 1) 2) 3) 4) 5) 6) ● ● ● Complete the chart to compute the issue (selling) price of the bonds on January 1, 2023. (1 point) Prepare an amortization schedule for the life of the bond issue. If done correctly, final book value should be within $1-$2 of $700,000 (due to rounding in the PV tables) (3 points) Prepare journal entries for the dates indicated. Type account titles, use cell references for debit and credit amounts. You do not need to indent account title credits as long as the numerical amounts are in the correct (debit or credit) column. Be sure credits come after all debits in a given entry. Also- no entries can contain negative numbers (i.e. a negative credit indicates the account should be debited and vice versa). (3 points) Compute the bonds' market value on January 1, 2025 (for cell E56, use cell reference D4, rather than $700,000 so the question recomputes when the original issue price is changed). (1 point) Prepare the entry to retire 30% of the bonds on January 1, 2025. (2 points) Working spreadsheet - when grading the spreadsheet, I will replace the $700,000 face value of the bonds in cell D4 with $800,000 and verify the spreadsheet correctly recalculates amounts.
Expert Answer:
Answer rating: 100% (QA)
Here are the stepbystep calculations for each question 1 Original Bond Issue Face value of bonds giv... View the full answer
Related Book For
Financial Accounting
ISBN: 978-1259222139
9th edition
Authors: Robert Libby, Patricia Libby, Frank Hodge
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
e ed " te 3 TH of DE ti Quiz: Quiz Chapter 1 This Question: 2 pts n fi Cash Paid Upon issuance of the bonds payable, the company received $9200 Requirement 2. Prepare an amortization table for the...
-
Company A has the following investments as of January 1, 2019: 1. 5,000 shares (5% ownership) of Company Z with an original cost of $150,000 and 10,000 shares (10% ownership) of Company Y with an...
-
Extend the model of this chapter by assuming that the firms cost function has the form C(X,E) satisfying assumption 5.1. (a) Derive the second-best optimal combination of an emission standard (no...
-
In auditing the Train Company, you obtain directly from the bank Trains bank statement, canceled checks, and other memoranda which relate to the companys bank account for December 2007. In...
-
On 1 April 2023, Pedantic acquired 60% of the equity share capital of Sophistic in a share exchange of two shares in Pedantic for three shares in Sophistic. The issue of shares has not yet been...
-
Both the suction and discharge piping for the pump shown in Fig. P12.22 consist of 4-in. I.D. 40-ft-long plastic pipe. Find the volume flow rate of \(60{ }^{\circ} \mathrm{F}\) water through the...
-
Beckett Industries manufactures a popular interactive stuffed animal for children that requires two computer chips inside each toy. The company pays $ 3 for each computer chip. To help to guard...
-
It is evident that Central Banks in advanced capitalist nations such as Australia are serious about reducing annual CPI inflation, which was 5.4 per cent in the September 2023 quarter. Raising the...
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
QUESTION ONE: (CONTRACT LAW) Sam is a painting contractor who decides tohiresome ladders andplanksfromalocal equipment hiring business toenablehimtopainttheexteriorof a client's home.Whenhecollects...
-
For what type of project is a line-of-balance schedule particularly suited? Identify specific examples.
-
Why is it important for the project manager to be accurate in the submission of pay applications? What is lost if the amount requested is low? What is the risk if the amount requested is more than...
-
Why is production cost reduction the primary means to deal with cost overruns?
-
Why does the placement of blame have no place in the postproject evaluation process?
-
What advantage does an Earned Value Management System have over more traditional cost-control and schedule-control systems?
-
Felix plans to pay a $0.75 dividend next year, then grow it by 12% for the next three years, before growing it by 8% indefinitely thereafter. The stock has a required market yield of 10%. What should...
-
Discuss whether responsible human resources management should apply different standards for the home company and suppliers, for developed countries and developing countries, and for large companies...
-
Match each ratio or percentage with its computation. Ratios or Percentages 1. Net profit margin 2. Inventory turnover ratio 3. Average days to collect receivables 4. Dividend yield ratio 5. Return on...
-
Computer Service and Repair was started five years ago by two college roommates. The company's comparative balance sheets and income statement are presented below, along with additional information....
-
Exxon Mobil Corporation explores, produces, refines, markets, and supplies crude oil, natural gas, and petroleum products in the United States and around the world. The following are accounts from a...
-
Natasha Kingery is 30 years old and has a Bachelor of Science degree in computer science. She is currently employed as a Tier 2 field service representative for a telephony corporation located in...
-
This is your second interview with a prestigious brokerage firm for a job as an equity analyst. You survived the morning interviews with the department manager and the vice president of equity....
-
On 1 January 2023, Blue Jay Ltd revalued land from \(\$ 300000\) to \(\$ 500000\). On 1 January 2024, the company subsequently revalued the land to \(\$ 420000\). And on 1 January 2025 , the company...
Study smarter with the SolutionInn App