Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

how to do this on excel? A Canadian-controlled and private mail-order computer company in Truro, Nova Scotia, sells computer supplies and peripherals. The company leased

image text in transcribedhow to do this on excel?

A Canadian-controlled and private mail-order computer company in Truro, Nova Scotia, sells computer supplies and peripherals. The company leased showroom space and a warehouse for $30,000 a year and installed $120,000 worth of inventory checking and packaging equipment. The CCA rate for this investment is 30%. The life span of the project is 5 years. The salvage value is $$15,000. The MARR is 12%. The store was completed and operations began on January 1. The company had a gross income of $1,500,000 annually. Annual supplies and all operating expenses other than the lease expense were itemized as follows: Costs of Good Sold $500000 Salaries $250000 Other Expenses $100000 Total Expenses $850000 How much will the company pay in federal and provincial income taxes in each of the 5 years? (80 marks) I Find the net present worth of the project (20 marks) A Canadian-controlled and private mail-order computer company in Truro, Nova Scotia, sells computer supplies and peripherals. The company leased showroom space and a warehouse for $30,000 a year and installed $120,000 worth of inventory checking and packaging equipment. The CCA rate for this investment is 30%. The life span of the project is 5 years. The salvage value is $$15,000. The MARR is 12%. The store was completed and operations began on January 1. The company had a gross income of $1,500,000 annually. Annual supplies and all operating expenses other than the lease expense were itemized as follows: Costs of Good Sold $500000 Salaries $250000 Other Expenses $100000 Total Expenses $850000 How much will the company pay in federal and provincial income taxes in each of the 5 years? (80 marks) I Find the net present worth of the project (20 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

0130674842, 978-0130674845

Students also viewed these Finance questions