Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have attached a spreadsheet please help. I included the problem below. I need help in making sure my numbers are correct and the categories

I have attached a spreadsheet please help. I included the problem below. I need help in making sure my numbers are correct and the categories in the spreadsheet.

Early in its fiscal year ending December 31, 2013, San Antonio Outfitters finalized plans to expand operations. The first stage was completed on April 30th with the purchase of a tract of land on the outskirts of the city. The land and existing building were purchased for $800,000. San Antonio paid $200,000 and signed a noninterest-bearing note requiring the company to pay the remaining $600,000 on April 30, 2015. An interest rate of 8% properly reflects the time value of money for this type of loan agreement. Title search, insurance, and other closing costs totaling $20,000 were paid at closing.

During April, the old building was demolished at a cost of $70,000, and an additional $50,000 was paid to clear and grade the land. Construction of a new building began on May 1 and was completed on October 29. Construction expenditures were as follows:

San Antonio borrowed $3,000,000 at 8% on May 1 to help finance construction. This loan, plus interest, will be paid in 2014.

In November, the company purchased 10 identical pieces of equipment and office furniture and fixtures for a lump-sum price of $600,000 on account. The fair values of the equipment and the furniture and fixtures were $455,000 and $245,000, respectively.

In December, San Antonio paid a contractor $285,000 for the construction of parking lots and for landscaping.

Below is the trial balance for San Antonio Outfitters as of March 31.

SAN ANTONIO OUTFITTERS

Trial Balance March 31, 2013

Debit Credit

Cash .......................................................................................... $3,394,380

Accounts receivable ............................................................... 2,129,500

Prepaid insurance ................................................................... 42,300

Office equipment .................................................................... 119,300

Accumulated Depreciation, Office Equipment .................. $11,750

Inventory .................................................................................

2,104,000

Building ...................................................................................

100,000

Land..........................................................................................

720,000

Accounts payable ...................................................................

$ 104,410

Notespayable..........................................................................

600,000

San Antonio, Capital ..............................................................

2,541,700

San Antonio, Withdrawals ....................................................

10,450

Revenue ...................................................................................

6,144,100

Wages expense ........................................................................

654,500

Depreciation Expense, Office Equipment ...........................

4,250

Equipment rental expense.....................................................

71,410

Office Supplies Expense ........................................................

7,500

Advertising expense...............................................................

32,400

Repairs expense ......................................................................

11,970

Totals ........................................................................................

$9,401,960

$9,401,960

Calculation of Purchase price of land Amount

Cash Paid 200000

Value of Note 600000

P.V of note for n = 2 & I =8% 0.85734

P.V of note Payment 514404

Total Purchase Price 714404

Add: Closing costs 20000

Removal cost of Old Building 70000

Clearing & Grading cost of land 50000

Total Value of Land 854404

Building

Average accumulated expenditures;

31-May 1200000 * 5/ 6 1000000

30-Jul 1500000*3/6 750000

1-Sep 900000*2/6 300000

1-Oct 1800000*1/6 300000

Total Average Accumulated expenditure 2350000

Interest capitalized 94000

Total Construction Expenditure 5400000 (1200000+1500000+900000+1800000)

Add Interest Capitalized 94000

Total Cost of Building 5494000

Land Improvements

Parking Lot & Landscaping 285000

Fair value % of fair value Initial valuation

Equipment 455000 65.00% 390000

Furniture & Fixture 245000 35.00% 210000

Total 700000 600000

Interest expense

Note issued to Purchase land & Building 30864 Discount/Interest expense for 2013

Construction Loan 160000 Interest on construction loan for 2013

Total interest 190864

Less Interest capitalized -94000

Interest expense 96864

Where do these categories fit into the spreadsheet provided?

image text in transcribed Name San Antonio Outfitters Land Account 12/31/XXXX Land Purchase Grade Clear Land Title, Insurance, Closing Demolish Building 900,000 50,000 20,000 70,000 Totals San Antonio Outfitters Capitalized Cost of Ofifce Building 12/31/XXXX 30, May 20, July 1, September 1, October 1, November Totals $1,200,000 1,500,000 900,000 1,800,000 285,000 San Antonio Outfitters Schedule of Interest Expense 12/31/XXXX 31, May 1200000 30, Jul 150000 1 Sep 900000 1 Oct 180000 Totals $1,000,000 750,000 300,000 300,000 Lump Sum Purchase Land Building Equipment San Antonio Outfitters Land Improvements 12/31/XXXX Parking lot and landscaping um Purchase 720,000 100,000 71,410 nio Outfitters provements 31/XXXX $285,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Non-Accountants

Authors: David Horner

12th Edition

1789664306, 9781789664300

More Books

Students also viewed these Accounting questions

Question

1. Encourage students to set a small-step goal for one subject.

Answered: 1 week ago

Question

=+5. How can you show them their personal benefits?

Answered: 1 week ago

Question

=+7. How does it enhance their lifestyle?

Answered: 1 week ago