Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

UNIT I: EXCEL SPREADSHEET (30 POINTS) Using Excel, prepare in a professional manner the following spreadsheet: Prepare a spreadsheet with columns for Description, Land, Land

image text in transcribedimage text in transcribed

UNIT I: EXCEL SPREADSHEET (30 POINTS) Using Excel, prepare in a professional manner the following spreadsheet: Prepare a spreadsheet with columns for Description, Land, Land Improvements, Sales Building, Garage Building, and Furniture. Show how to account for each of Road Runner's costs by listing each cost's description then accounting for it in the appropriate column. Then determine the total cost for each column. Show the depreciation expense for each asset for the year ending December 31, 2019. All assets were placed in service in 2019. It is the company's policy to take a full year of depreciation in the year the asset is placed into service. Road Runner depreciates buildings over 40 years, land improvements over 20 years, and furniture over 8 years, all on a straight-line basis. Salvage values are as follows: land improvements, $1,000; sales building, $50,000; garage building, $5,000; and furniture, $2,000. When calculating depreciation expense, use the SLN function. The ROUND function should be used to round depreciation to the nearest ten dollars. (i.e. 1122, would round to 1120) Submit the following: 1. Spreadsheet. 2 Grading Rubric: Points - 19 for each item accounted for correctly 2 rounding to nearest ten 2 using @round function 5 for using formulas 2 for clarity of presentation - headings, layout... 30 points total 1 Road Runner High-Speed Online, Inc. incurred the following costs in acquiring its property and equipment: A $250,000 - Purchase price of four acres of land, including an old building that will be used for a garage (75% to land and 25% to building). B. $8,100 - Dirt and leveling of land. C. $17,650 - Fence around the land. D $600 - Attorney fee for title search on the land. E. $5,900 - Delinquent real estate taxes on the land to be paid by Road Runner. F. $1,800 - Company signs at front of the company property. G. $350 - Building permit for sales building. H. $19,800 - Architect fee for the design of sales building. 1. $923,000 - Construction costs of sales building. J. $41,800 - Renovation costs of the garage building. K. $9,000 - Interest during construction on loan for sales building. L. $6,400 - Trees and shrubs. M. $52,300 - Parking lot and concrete walks. N. $7,300 - Lights for the parking lot. 0. $107,100 - Furniture for the sales building. P. $1,800 - Transportation and installation of furniture. Q. $40,000 - supervisory salary of the construction supervisor (85% to sales building, 9% to land improvements; and 6% to garage building). 2

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

Managerial Accounting An Introduction to Concepts Methods and Uses

Authors: Michael W. Maher, Clyde P. Stickney, Roman L. Weil

10th Edition

1111822239, 324639767, 9781111822231, 978-0324639766

More Books

Students also viewed these Accounting questions

Question

What options are available for the treatment of missing data?

Answered: 1 week ago