Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started