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 to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Forecasting And Predictive Analytics With Forecast X

Authors: Barry Keating, J. Holton Wilson, John Solutions Inc.

7th International Edition

1260085236, 9781260085235

More Books

Students also viewed these Finance questions