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

  Show small inventory shortages

show small inventory shortages and 5 percent show large inventory shortages. KK firm has devised a new accounting test for which it believes the subsequent probabilities hold

  Compare the answers with the original plans

Suppose 200,000 units are sold, but only 20,000 are deluxe.  Compute the operating income.  Compute the breakeven point if these relationships persist in the next period.

  Part-1please respond to the following questions of

part-1please respond to the following questions of implementing activity data-driven cost components for health

  Prepare an income statement for the current year ended june

Prepare an income statement for the current year ended June 30, 2008 and prepare a statement of owner's equity for the current year ended June 30, 2008.

  Acme manufacturing manufactures and sells three products

acme manufacturing manufactures and sells three products. the following information pertains to acmes 2012 sales and

  Canned fruits and vegetables are the main products made by

canned fruits and vegetables are the main products made by yummy food inc. all direct materials are added at the

  Compute the budgeted cash payment for purchases

Purchases will be made in 12 equal monthly amounts and paid for in the following month. Compute the budgeted cash payment for purchases of Calvos for 2010.

  Identify and compare alternative renewable energy options

Each off the above projects is based on ideas for projects where there is significant information available in the form of technical guides, case studies, and from suppliers of technology. A quick Google search will furnish you with examples and ..

  Compute accrual and cash incomein its first year of

compute accrual and cash incomein its first year of operations harden co. earned 39000 in revenues and received 33000

  Compute the predetermined overhead rates

Compute the predetermined overhead rates assuming that Mets Products uses machine-hours to allocate machine-related overhead costs and materials costs to allocate materials-related overhead costs.

  Youcpa is a regional cpa firm engaged in public audit work

youcpa is a regional cpa firm engaged in public audit work of small- and medium-size firms in the midwest. the youcpa

  Would you advise jim to make this investment

He estimates that the equipment could be sold at that time for 4% of its original cost. Jim uses a 16% discount rate - would you advise Jim to make this investment? Why or why not?

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