Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. how do i properly allocate the purchase price betw

How do I properly allocate the purchase price between land, building, and office equipment in...

80.2K

Verified Solution

Question

Accounting

imageHow do I properly allocate the purchase price between land, building, and office equipment in excel using formulas?

On October 1 Computer Solutions purchased an office building for $473,000, which included land, building, and office equipment. The purchase was financed with a 30 year loan from the bank with an interest rate of 3% (ordinary annuity). The first payment is due November 1. Appraisal of the property came in at $525,000 with land appraised at $200,000; building, $275,000, and office equipment, $50,000. Using Excel, create an amortization of the loan (5 points) to determine the payment amount along with the allocation of the payments between principal and interest. Add a sheet to this file to calculate the allocation of the purchase price (5 points) between land, building, and

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

c In a singly ionized Helium atom the electron is in the third orbit A...

Physics
Q

How do taxes impact your accumulation? Why are marginal tax rates important instead of average? What rate...

Finance
Q

Conciderer the full-width rectangular pulses p(t). the rms value of AWGN is 10^-3V. A) Determine the necessary...

Electrical Engineering
Q

Copper has 8.5∙1028 free electrons per cubic meter. A 71.0 cm length of 12-gauge copper wire...

Electrical Engineering
Q

A student at a university has been doing a project to investigate entertainment habits of students....

Basic Math
Q

You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price...

Finance
Q

For the given differential equation complete the table with values in the slope field Then...

Calculus
Q

Future Value of Debt. Jim accepted a $5,000 loan from his uncle Kurt Uncle Kurt...

Accounting
Q

You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage...

Accounting
Q

que pasa cuando se me acaban las 20 preguntas y aun faltan dias para se...

Accounting
Q

*Holding cost =$1.50/ unit/week; setup cost =$200; lead time =1 week; beginning inventory =40. Develop...

Accounting
Q

The Williams Company Budgeting Example The Williams Company manufactures PVC piping in long pipes which...

Accounting