write a proposal in one page (maximum in two pages) to discuss in brief main types of
financial reports along with discussing in detail the idea (what do you understand, what are
the inputs and outputs) behind CW as a reporting excel tool to monitor the financial flow of
any construction company.
civl_0034_construction_finance_cw.pdf
civl_0034_construction_finance_cw.pdf
civl_0034_construction_finance_cw.pdf
Unformatted Attachment Preview
Student ID:
Family Name(s):
Forename(s):
Declaration:
I declare that this Coursework is my own work.
Cheating is a serious
offence. I have read and agree to abide by the University guidance on Academic Honesty.
I consent to appropriate storage of our work for plagiarism checking.
academic
Signature(s):
Time taken to complete assignment (hrs.):
Department: Civil Engineering
Module Title: Construction Finance
Module Code: CIVL 0034
Module Leader: Mr. Roy Mammen
Lecturer: Dr. Mahmoud Dawood
Date of Submission: 29 August 2016
Assignment Title: Course Work Assignment
Assignment Type: Individual
Estimated Time (hrs.): 10 hours
Learning Outcomes Assessed (or on separate sheet)
As on assignment
Assessment Criteria (or on separate sheet)
Max
Proposal
8%
Report &Excel Workbook
92%
Awarded
Penalty
Assessor’s signature:
Date:
Final Mark
Note
.
100
.
50
1. If you are unable to submit your work due to extenuating circumstances you may apply for an extension.
2. The MEC policy on Late Submission, Plagiarism, and on Assessed Coursework applies to this coursework. You are
advised to read the guidelines in the student handbook.
3. Don’t copy your colleagues’ work. Any copied part will not be accepted.
4. A student may be called for VIVA to discuss his work “if the instructor have a doubt regarding the source of the
work (outsourced)”.
Construction Finance (CIVL 0034)
Course Work Assignment (analysis of financial data using spreadsheets) – Summer 2016
Submission Date: 29 August, 2016
Total Marks: 50
Introduction
This is an individual coursework assignment to help student in distinguish key financial concepts
as used in companies’ reports and to understand the linkages between the different types of
financial report. This will assist quantity surveying and construction management students to
gain knowledge and understanding in reporting and critically analyse of financial data. On the
other hand, it will create a base for understanding of basic accounting and financial principles,
to examine issues of finance applicable to the construction firm and its projects and apply
spreadsheet techniques to analyse financial problems.
Outcomes of the assignment
Distinguish key financial concepts as used in company reports and understand the linkages
between the different types of financial report.
TASK:
In this assignment, students will have hands-on experience in developing an integrated
framework for controlling, monitoring, and analysis of company financial information. In
addition the task aims to help the student understand financial issues from a corporate
management perspective. It will provide the platform for continuing management
development.
Data:
All required data are given in the attached “CF-Coursework-Data” Excel sheet. Assuming the
current date is January 2017, the up to date financial reports’ (Balance Sheet, Income
Statement and Statement of Cash Flow) data are given in Table1, Table2, and Table 3
respectively.
Also,
the
additional
transaction
data
are
given
in
Table 4.
Requirements:
The students are required to develop a report (not less than 10 pages) along with Excel
spreadsheets as an aid in preparing and updating of financial reports. Each student is requested
to:
CIVL0034-Construction Finance
Page 2 of 9
1. Submit a proposal in one page (maximum in two pages) to discuss in brief main types of
financial reports along with discussing in detail the idea (what do you understand, what are
the inputs and outputs) behind CW as a reporting excel tool to monitor the financial flow of
any construction company. The proposal mark is 10% (maximum) of the CW marks and
should be submitted by students during the 1st week (from the uploading date of the
assignment by the instructor to the Moodle).
2. Use the given transaction data (Table 4) to update the missed items in the final financial
reports and critically discuss the company financial performance trend (use Excel Formulas
to do any required calculations and create Excel charts as a helping tool in the analysis of
financial trend “Horizontal Analysis”).
3. Use Excel (along with creating charts) to evaluate the depreciation of the equipment at the
end of every year (2014, 2015, and 2016) of its service life using Declining Balance (DB), and
Sum-of Years Digits (SYD) methods.
4. Based on the financial ratios’ calculations, critically discuss in detail the company financial
position and the linkages between the different types of financial report (use Excel
Formulas to calculate financial ratios and use Excel charts to support your discussion).
Notes:
a. A student may be called for VIVA to discuss his work “if the instructor have a doubt regarding the
source of the work (outsourced)”.
b. Any missing/incorrect data should be reasonably assumed after getting instructor approval.
c. A student should use his own data without change otherwise his report will not marked.
Report Format
Number of pages: Maximum 20 pages including attached Excel sheets and references list
and the appendix (if any).
Line spacing: Generally use 1.5 x line spacing.
Start with the title page including your name and/or ID as requested.
It is preferable to place figures within the text rather than group them at the end of the
report.
Give a sequential number to all figures (Fig. 1, Fig. 2, Fig. 3, etc.)
Add a brief, informative caption to all inserted figures and tables.
All figures and all tables should be introduced and discussed in detail.
Unclear figures will not accepted.
Follow Harvard referencing style and references should be cited in the report body.
All report pages should have numbers (e.g. Page 1 of 15, Page 2 of 15, etc.)
Any inserted text as images will not accepted.
CIVL0034-Construction Finance
Page 3 of 9
Any tricky process to reduce the similarity ratio will not be accepted.
Report Sections
The Report should contain the following sections:
1.
Abstract (Executive summary)
Table of contents
Introduction
Report body
Conclusions
References
Abstract (minimum 1/2 page)
The abstract must be brief, but it has to tell the following:
2.
3.
The main objective.
Methodology (write about the main sections involved in the report).
Short conclusion (one or two sentences are recommended).
Table of content
Include heading, subheading, page numbers, list of figures and tables.
Introduction (minimum 1 pages)
The introduction is very important as it sets the context for the report. Summarize the brief
and focus on its significance, state the report’s aim (objective), and describe how the report is
organized (methodology). It is not usual to detail findings or recommendations in the
introduction.
4.
Report body (minimum 8 pages)
The previous sections (abstract, table of contents, introduction) are preliminary sections. Case
study’s body section is organized as follows:
5.
The headings are informative and descriptive.
Discuss the conceptual framework of the essay topic.
Expound or elaborate the concept by presenting sub –topics relevant to the main topic.
Conclusions (minimum 1/2 page)
Every report should include a concluding statement/s on the subject of the report. Restate the
aim of the report and state how you have achieved it. Present the main findings and key
recommendations in a summarized. You should also restate the limitations of the report.
CIVL0034-Construction Finance
Page 4 of 9
6.
References
This is a list of all the sources of information you have referred to in the report (follow Harvard
references format); minimum 8 references. All references listed at the references list should
be provided in the text properly.
7.
Appendix
Any additional figures, tables, and photos if required
Guidelines
Follow the guidelines mentioned below for your assignment.
Assignment should be typed and an electronic copy is to be submitted through Moodle
(as a Turnitin)
Handwritten assignments will not be accepted
The assignment should not be more than 20 pages in (size A4) paper.
Assignment should have Complete and sign the cover sheet with the following
information
o Assignment Title
o Class
o Student name
o Student ID
It should have Table of Contents, List of Figures and List of Tables.
Use page numbers
Assignment should be typed in your own words using Times New Roman font size 12.
Heading should be with Font Size 14, Bold.
Use Diagrams and Examples to explain your topic and provided citation.
You are encouraged to refer the books in Library or use internet resource or computer
magazines or any other resource but you should not cut/copy and paste from internet.
Copy paste from the Internet is strictly not acceptable.
Harvard referencing style must be followed.
Wikipedia is not accepted as a reference.
CIVL0034-Construction Finance
Page 5 of 9
Late Submission
Penalty for late submission – 5% of the obtained marks for the assessment will be deducted for each
working day.
Assessment documents submitted beyond a period of five working days after the last date of
submission will not be accepted and will be marked as zero for that assessment.
Plagiarism Policy
Plagiarized documents, in parts or whole, submitted by the students will be rejected. For the first
offence of plagiarism, a student enrolled in undergraduate programme is penalized with a deduction
of 25% of the obtained marks on the assessment as per the plagiarism policy statement and is
allowed to re-submit the work once, within five working days. The student has the right to appeal
against the decision made, to the respective Programme Manager. Further appeal on decision taken
may be made to the Head of the concerned department. If the student is not satisfied by the
decisions taken by the department, s/he can appeal to the Plagiarism Appeals Committee.
For policies or any other related information to Plagiarism please refer to the Student
Guide/Handbook page no 38-40.
Clarification on Plagiarism Policy
As per MEC policy, any form of violation of academic integrity will invite severe penalty. Plagiarized
documents, in part or in whole, submitted by the students will be subject to this policy.
A. First offence of plagiarism
A student will be allowed to re-submit the assignment once, within a maximum period of one
week. However, a penalty of deduction of 25% of the marks obtained for the resubmitted work
will be imposed.
Mark deduction: When the work is resubmitted, the marking will be undertaken according to
the marking criteria. In compliance with this policy, the 25% deduction is then made on the
marks obtained. For example, in an assessment that carries a maximum of 50 marks, suppose a
student were to obtain 30 marks for the resubmitted work, the final marks for that assessment
will be 22.5 (after deducting 25% of the marks actually obtained for the resubmitted work).
Period of resubmission: The student will have to resubmit the work one week from the date he
or she is advised to resubmit. For example, if the formal advice to resubmit was communicated
to the student on a Sunday (latest by 5 pm), the student will have to resubmit the work latest by
next Sunday 5 pm.
If the re-submitted work is also detected to be plagiarized, then the work will be awarded a
zero.
Resubmission of the work beyond the maximum period of one week will not be accepted and
the work will be awarded a zero.
CIVL0034-Construction Finance
Page 6 of 9
B. Any further offence of plagiarism
If any student is again caught in an act of plagiarism during his/her course of study (either in the
same module, same semester or in any other semester), the student will directly be awarded
zero for the work in which plagiarism is detected. In such cases, the student will not be allowed
to re-submit the work.
C. Guidelines
Type 1: In case plagiarism is detected in any component or part submission (submitted at
different times) of one assessment (assignment), the deduction in marks will be applicable for
the whole assessment (assignment), even if only the component or part submission alone needs
to be resubmitted.
Type 2: In case plagiarism is detected in a group assessment, all students of the group will be
considered as having committed an act of plagiarism irrespective of whether plagiarism is on
account of the act of all or a few or only one member. The policy will then be applied to all
students.
Type 3: Combination of Type 1 and Type 2: In case plagiarism is detected in any component or
part submission (submitted at different times) of a group assessment (assignment), the
deduction in marks will be applicable for the whole assessment (assignment), even if only the
component or part submission alone needs to be resubmitted. All students of the group would
be considered as having committed an act of plagiarism irrespective of whether plagiarism is on
account of the act of all or a few or only one member. The policy will then be applied to all the
students of the group.
Type 4: Variation of Type 1 and Type 2: In cases where the assessment consists of components
or part submissions that could be a group assessment component (e.g. group assignment) and
an individual assessment component (e.g. individual reflection), the following will be applicable:
o
If plagiarism is detected in the group assessment component, all students of the group
will be considered as having committed an act of plagiarism, irrespective of whether
plagiarism is on account of the act of all or a few or only one member. The policy will
then be applied to all students of the group. In such cases the group assessment
component will be resubmitted as per the policy.
o
If plagiarism is detected in the individual assessment component, the individual
assessment component will be resubmitted as per the policy. The policy will then be
applied to that student alone.
o
In both cases (a) and/or (b), the deduction in marks will be applicable for the whole
assessment (assignment).
D. Amount of similar material
The total amount of similar material in any form of student work from all sources put together
should not exceed 30% (including direct quotations).
The total amount of quoted material (direct quotations) in any form of student work from all
sources put together should not exceed 10%.
CIVL0034-Construction Finance
Page 7 of 9
The total amount of similar material in any form of student work from a single source should not
exceed 7 percent. However, cases having a similarity of less than 7 percent in such cases may
still be investigated by the faculty depending on the seriousness of the case.
If faculty member find enough merit in the case of a student work with a similarity (with a single
source) of more than 7 percent as not a case of plagiarism, the faculty member should provide
detailed comments/remarks to justify the case.
ASSESSMENT:
50% OF FINAL MARK
Assessment Sheet – Basic Assignment Analysis:
Task
All
Very weak
Weak
Very weak analysis Weak
or
Weak
understanding
understanding and Too descriptive
exposition
of
and
analysis
relevant issues
incomplete
Some awareness
A few relevant
but also confusing
points
but
Arguments
not
superficial/confus
clear
ed No grasp of
No evidence – too
analysis and many
reliant on class
errors
notes
No evidence –
Superficial
use
poor
and
poorly
understanding of
referenced
class notes
Poor or no use
of data or
examples
Good
Excellent
Marks
Good
Clear
Attempts
but
awareness
with errors and Good
omissions
evaluation
Shows awareness
and synthesis
but limited
Relevant and
Insufficient
referenced
evidence
Insufficient
evaluation
Some good but
incomplete
references
Adequate
awareness
Evidence
Poor or no use of
data
and
references
no
CIVL0034-Construction Finance
Page 8 of 9
CIVL 0034 – Construction Finance (Summer 2016)
Student ID……………………….……………… Student Name:………………………………………………………………………….
Tasks
Assignment Evaluation Grid*
Bad/ poor
Average
Good
Excellent
a. Proposal**
8%
b. Report structure/Writing & Spreadsheets
1.
2.
3.
4.
Report Format.
Abstract.
Introduction.
Preparing/Revising the financial
reports.
5. Depreciation Analysis and Discussion
6. Critically discuss the revised financial
reports, company financial
4%
4%
10%
12%
7%
performance trend and the linkages
between the different types of
report (based on Excel calculations
and charts).
15%
7. Financial Ratios calculations using
Excel spreadsheets.
8. Critically Analysis of Financial ratios
and discuss the company financial
position/performance (based on
Excel calculations and charts).
9. Conclusion.
10. References & Citation.
* A student may be called for VIVA to discuss his work “if the
instructor have a doubt regarding the source of the work
(outsourced)”.
** The proposal should be submitted by the student within a
week from the uploading date to the Moodle.
15%
15%
6%
4%
Total Marks
.
100
Penalty:…………………………….
Final Marks
.
100
Overall Marks (…./50)
Student Signature:
CIVL0034-Construction Finance
.
50
Similarity Ratio is ……………..%
Page 9 of 9
Student ID:
Family Name(s):
Forename(s):
Declaration:
I declare that this Coursework is my own work.
Cheating is a serious
offence. I have read and agree to abide by the University guidance on Academic Honesty.
I consent to appropriate storage of our work for plagiarism checking.
academic
Signature(s):
Time taken to complete assignment (hrs.):
Department: Civil Engineering
Module Title: Construction Finance
Module Code: CIVL 0034
Module Leader: Mr. Roy Mammen
Lecturer: Dr. Mahmoud Dawood
Date of Submission: 29 August 2016
Assignment Title: Course Work Assignment
Assignment Type: Individual
Estimated Time (hrs.): 10 hours
Learning Outcomes Assessed (or on separate sheet)
As on assignment
Assessment Criteria (or on separate sheet)
Max
Proposal
8%
Report &Excel Workbook
92%
Awarded
Penalty
Assessor’s signature:
Date:
Final Mark
Note
.
100
.
50
1. If you are unable to submit your work due to extenuating circumstances you may apply for an extension.
2. The MEC policy on Late Submission, Plagiarism, and on Assessed Coursework applies to this coursework. You are
advised to read the guidelines in the student handbook.
3. Don’t copy your colleagues’ work. Any copied part will not be accepted.
4. A student may be called for VIVA to discuss his work “if the instructor have a doubt regarding the source of the
work (outsourced)”.
Construction Finance (CIVL 0034)
Course Work Assignment (analysis of financial data using spreadsheets) – Summer 2016
Submission Date: 29 August, 2016
Total Marks: 50
Introduction
This is an individual coursework assignment to help student in distinguish key financial concepts
as used in companies’ reports and to understand the linkages between the different types of
financial report. This will assist quantity surveying and construction management students to
gain knowledge and understanding in reporting and critically analyse of financial data. On the
other hand, it will create a base for understanding of basic accounting and financial principles,
to examine issues of finance applicable to the construction firm and its projects and apply
spreadsheet techniques to analyse financial problems.
Outcomes of the assignment
Distinguish key financial concepts as used in company reports and understand the linkages
between the different types of financial report.
TASK:
In this assignment, students will have hands-on experience in developing an integrated
framework for controlling, monitoring, and analysis of company financial information. In
addition the task aims to help the student …
Purchase answer to see full
attachment
Recent Comments