Solved Assignments

Brooks_Chapter_4_2_Start – Amortization schedule. Sherry and Sam want to purchase a condo at the coast

Amortization schedule. Sherry and Sam want to purchase a condo at the coast. They will spend $650,000 on the condo and are taking out a $650,000 loan for the condo for twenty years at 7.0% interest. What is the annual payment on the mortgage? Construct the amortization schedule of the loan for the twenty years in a spreadsheet to show the annual interest costs, the principal reduction, and the ending balance each year. Then change the amortization schedule to reflect that after ten years Sherry and Sam will increase their annual payment to $80,000 per year. When will they fully repay the mortgage with this increased payment if they apply all the extra dollars above the original payment to the principal?…

Details

ACCT6001 Accounting Information Systems – Mark Richardson has recently opened an online store

The Flying Store   Mark Richardson has recently opened an online store named The Flying Store. He sells a very popular model of drone called the ‘Rocket Drone’. In an effort to widen his market, Mark has built a small website hosted by a web service provider. At the end of every week, the web service provider sends a data file to Mark that contains data about visitor traffic at his website. Mark would like to utilise this data to get insights on visitor usage of his website and he believes that the data would be valuable for business decision making. However, Mark lacks the technical knowledge to analyse and interpret this data and he is unsure how the results from…

Details

Certus Car Rental – John Tretow is an account manager

Data File needed for this case Problem: NP_eX_4-3.xlsx Certus Car Rental John Tretow is an account manager for the Certus Car Rental, an industry-leading car rental firm that serves customers across the United States and overseas. John is developing a market report for an upcoming sales conference and needs your assistance in summarizes market information into a collection of Excel charts and graphics. Complete the following. Open the NP_eX_4-3.xlsx workbook located in the Excel4 > Case1 folder included with your Data Files. Save the workbook as NP_eX_4_certus in the location specified by your instructor. In the Documentation sheet, enter your name and the date in the range B3:B4. John wants the report to include pie charts that break down the current…

Details

ACCG2000 Excel Assessment – JJ Cycles Ltd produce two high end bicycle

Scenario JJ Cycles Ltd produce two high end bicycle products at two different factories. They need you to create a spreadsheet that can conduct a Cost Volume Profit Analysis for a selected product line.  You can assume that sales price, fixed costs, and variable cost per unit are constant. You will need to calculate the labour costs, material costs, fixed costs and variable costs and then work out the break-even volume.  You have also been asked to show a forecast for different unit volumes and produce a break-even analysis line chart.   Start by downloading the assessment workbook from iLearn and copying/moving it to an appropriate folder. When you open the workbook it is very important that you Enable Macros and…

Details

New Perspectives Excel 2019 | Module 8: SAM Project 1b

Ferguson Fitness EXPLORE BUSINESS OPTIONS WITH WHAT-IF TOOLS       GETTING STARTED Open the file NP_EX19_8b_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_8b_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_8b_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. This project requires you to use the Solver add-in. If this add-in is not available on…

Details

Brooks_Chapter_3_1

Project Description: In this problem, you will prepare a portfolio growth model to determine how long it will take a couple to reach their retirement goal.   Steps to Perform: Step Instructions Points Possible 1 Start Excel. Download and open the workbook named: Brooks_Chapter_3_1_Start. 0 2 In cell D19, by using cell references, calculate the future value of the money market account after one year. Use the Excel FV function. Make absolute references to the account balance in cell D18 and the relevant growth rate from the Given Data section. Note: The output of the function you typed in this cell is expected as a positive number. 1 3 In cell E19, by using cell references, calculate the future value of…

Details

Brooks_Chapter_14_2

Project Description: In this problem, you will determine some financial ratios for Procter & Gamble and Johnson & Johnson based on their financial statements for the most recent years.   Steps to Perform: Step Instructions Points Possible 1 Start Excel. Download and open the workbook named: Brooks_Chapter_14_2_Start. 0 2 In cell D74, by using cell references, calculate the net profit margin percentage for Procter & Gamble in year 2017. Use the relevant cells from the Given Data section. 1 3 In cell D75, by using cell references, calculate the inventory turnover for Procter & Gamble in year 2017. Use the relevant cells from the Given Data section. 1 4 In cell D76, by using cell references, calculate the current ratio for…

Details

GO16_AC_CH02_GRADER_2F_HW – Student Publications (MyItLab)

Project Description: In this project, you will use a database to answer questions about student publications at a college. You will import an Excel spreadsheet as a new table in the database, create a relationship between two tables, and create queries using numeric, compound, and wildcard criteria using the fields in one or both tables. You will create calculated fields, group data when calculating statistics, create a crosstab query, and create a parameter query.   Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Access. Open the downloaded file named go_a02_grader_h2_Student_Publications.accdb. 0 2 Import the records from the downloaded Excel file named go_a02_grader_h2_Student_Papers.xlsx as a new table named…

Details

GO16_AC_CH01_GRADER_1E_AS – Computer Club Inventory (MyItLab)

Project Description: In this project, you will create database objects to track the inventory of new computer parts used by the Computer Club. You will create a table and import data from Excel to create a second table. You will create a simple query, a form, and a report. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Access. Open the downloaded file named a01_grader_a1_Computer_Club.accdb, enable the content, and then open the Inventory table. 0 2 Beginning in the second column of the Inventory table and using the specified data types, create the following fields (in this order): Part (Short Text), Room (Short Text), Cabinet Location (Short Text),…

Details

Excel – The tvseries.xlsx workbook contains eight (8) worksheets

Background Info The tvseries.xlsx workbook contains eight (8) worksheets (Sheet1 to Sheet7 and Original Data worksheets). Sheet1 worksheet contains excerpts of TV series information with the advertisement cost (values in dollar) for each 30 seconds time slot during the show in 2018 and 2019. You are tasked to complete this worksheet with the necessary formula and charts, as well as make it presentable. Sheet2 to Sheet7 worksheets serve different purposes, you will need to prepare them for each of those intended purposes as listed. Original Data worksheet contains the copy of the original data used in worksheets Sheet2 to Sheet7. If you need a fresh copy, you can duplicate this worksheet and rename it accordingly. Do not make any changes to…

Details

Wombat company has identified the following overhead activities

Wombat company has identified the following overhead activities, costs and cost drivers for the coming year:   Activity  Expected costs Cost driver  Activity capacity Setup costs           $60,000 No. of setups              300 Ordering costs           45,000 No. of orders           4,500 Machine costs           90,000 Machine hours        18,000 Receiving           25,000 No. of parts        50,000   The following two jobs were completed during the year:   Job 600 Job 700 Direct material  $       750  $       850 Direct labour (50 hours per job)  $       600  $       600 Units completed 100 50 Number of setups 1 1 Number of orders 4 2 Machine hours 20 30 Parts used 20 40   The company’s normal activity is 4000 direct labour hours…

Details

On 1 July 2019 Ethan Ltd acquired 90% the issued shares of Davis Ltd

On 1 July 2019 Ethan Ltd acquired 90% the issued shares of Davis Ltd for $ 3,832,000. The equity of Davis Ltd at this date consisted of: Share capital: $ 1,341,000 Retained earnings: $ 575,000 General reserve: $ 460,000 All the identifiable assets and liabilities of Davis Ltd were recorded at amounts equal to their fair values at acquisition date except for the following: Account Cost Carrying Amount Fair Value Future life-in Year Inventories   575,000 1,035,000   Land   1,150,000 2,070,000   Vehicle 1,609,000 1,341,000 2,414,000 5 Fittings 60,425 56,950 63,900 5 Liabilities (Contingent)   0 50,000     All inventories on hand at 1 July 2019 are sold by 30 June 2020. Further life of the assets are listed…

Details