Utilize the related function in an electronic spreadsheet

Assignment Help Cost Accounting
Reference no: EM13851476

Each of the following scenarios is independent. Utilize the appropriate future value or present value table, and calculate the requested amount. Then, if available, utilize the related function in an electronic spreadsheet (or financial calculator) to verify your calculation.

(a) How much will a lump sum of $10,000, invested at 7% per annum, grow to in 20 years?

(b) How much will be in account after 2 years, if $50 is placed into the account at the beginning of each month? Assume the account's interest rate is 6%, with monthly compounding.

(c) How much should be set aside today, so that it will grow to $30,000 in 15 years? The discount rate is 9%.

(d) What is the present worth of an income stream that includes annual end-of-period payments of $100,000 for 20 years? Assume the appropriate discount rate is 8% per year.

"Rodriquez Oil and Gas borrowed $1,000,000 from a local bank to obtain funds needed for the construction of a new drilling rig. This ""construction"" loan was represented by a 2-year, 7%, promissory note, dated April 1, 20X3. Interest (only) is payable on March 31, 20X4, and again at maturity. The $1,000,000 principal is due on March 31, 20X5. Rodriguez repaid the promissory note on March 31, 20X5, as agreed.
"
On April 1, 20X5, Rodriguez secured permanent equipment financing via a $1,200,000, 5-year loan. This loan was at 6% per annum, and requires level quarterly payments so that the loan will be completely repaid at its maturity.

(a) Prepare journal entries for the $1,000,000 loan to record the loan's issuance (April 1, 20X3); accrued interest at December 31, 20X3; the

interest payment on March 31, 20X4; accrued interest at December 31, 20X4; and the final payment at maturity (March 31, 20X5).

(b) Calculate the required quarterly payment for the 5-year loan.

(c) Prepare journal entries to record the 5-year loan, and its first two quarterly payments.

(d) Optional: Use an electronic spreadsheet to prepare a 20-quarter amortization schedule, showing how the loan will be fully amortized by its maturity.

Reference no: EM13851476

Questions Cloud

What was the level of detail : Describe your experience at your company regarding any projects you are, or have been, assigned. Were you provided a Project Charter or Scope Statement? If so, what were the components of the document and what was the level of detail? Sometimes manag..
To persuade end-users to specify the company products : What can Johnny Tan do to revitalize his demoralized sales force? To persuade end-users to specify the company's products when purchasing from distributors
What is the npv of the given project : What is the NPV of the project? What if the machine will be depreciated using straight line depreciation over 6 years what will be the NPV of the project?
How would you approach the case listed under cips : How would you approach the case listed under cips/tice? What are some things to consider and thoughts? What numbers would you solve for and how?
Utilize the related function in an electronic spreadsheet : Utilize the appropriate future value or present value table, and calculate the requested amount. Then, if available, utilize the related function in an electronic spreadsheet (or financial calculator) to verify your calculation.
What would an investor be willing to pay for common stock : What would an investor be willing to pay for common stock in a firm that has no growth opportunities but pays dividends of $6.00 per year, starting today?
Privileged fly : You are a privileged fly:  You are allowed to be on the wall of a corporate boardroom during a high-powered discussion.  The corporation is an engineering firm whose sales total approximately $140 million a year.  Up to now, things appear to have bee..
Consumer choice model : Consumer Choice Model, Do you think diminishing marginal utility is a necessary condition to get diminishing MRS? Use your answers for (a), (d), and (e) to justify your answer.
Characteristics of the various victim wounds : Identify, discuss and debate the characteristics of the various victim wounds in the crime scene photographs of the 7 year old female victim below.

Reviews

Write a Review

Cost Accounting Questions & Answers

  What is her cost of underestimating the expenses

What is her cost of underestimating the expenses - Rosa puts $5,000 into her flexible benefits account, and her actual expenses are only $3,000. What is her cost of overestimating her expenses?

  Variable costing and absorption costing

Explain the difference in income between the variable costing and absorption costing statement

  Sir grapefellow tired of selling world war i era

sir grapefellow tired of selling world war i era merchandise for years is currently thinking of entering the breakfast

  What is included in retained earnings

What is included in retained earnings and how does distributing assets (paying dividends) to owners affect the accounting equation?

  Effect of collecting accounts receivable on the accounting

Effect of collecting accounts receivable on the accounting equation and financial statements - Why are the answers to Requirements b and c different?

  Prepare income statement based on absorption costing

ABC limited sells its product at 3 rupees per unit. The company uses a First-In First-Out actual costing system. Prepare income statement based on: Absorption costing

  Determine the monthly volume

Determine the monthly volume at which the proposed process becomes preferable to the current process.

  What do you estimate the firm current stock price to be

Its earnings are expected to grow forever at a rate of 4% per year. If its next dividend is due in one year, what do you estimate the firm's current stock price to be?

  What was the cost of goods manufactured for the year

How much of the materials in above consisted of indirect materials and how much of the factory labor cost for the year consisted of indirect labor?

  Prepare an income statement to determine cost approach

In this activity you will prepare one of the most use financial statements in business, the Income Statement. Arrange an answer to problem.

  Evaluate the amount of cash expected to be collected in july

Evaluate the amount of cash expected to be collected in July

  Prepare a schedule of lease receipts for cherry ltd

Prepare a schedule of lease receipts for Cherry Ltd and the journal entries for the year ended 30 June 2011 and prepare a schedule of lease payments for Hazel Ltd and the journal entries for the year ended 30 June 2011.

Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd